AD 79-10-14 R1
Registered aircraft · 56,582
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N52TDClear Sky 2020 LLC · Warner Robins, GAN52TMJorgensen Aviation Inc · Richfield, UTN52WJGordon Donald G · Woodburn, INN53006Hemphill Holdings LLC · Hemphill, TXN53009Triple V Aviation LLC · Long Valley, NJN5300ARunzel Brothers Aviation LLC · Bensenville, ILN5300CBerg Robert M · Culver, ORN5300KSliviak Thomas V · Leechburg, PAN5300QHopson Larry K · Conroe, TXN53010L & T Aviation Inc · Frederick, MDFirst renewal noticeN53013Metzler Alan J · Reedsville, PAN53017Johnston Charles L II · Nashville, TNN5301EMaxwell Don P II · Longview, TXN53020Iasco Flight Training Inc · Redding, CAN53023N53023 Aloha LLC · Palm City, FLN53025Beumer Ted Anthony · Pensacola, FLN53026Oehl Robert · Jacksonville, FLN53029N53029 Cardinal LLC · Rosharon, TXN5302CMiller Roy A · Maquoketa, IAN5302NNorthwoods Air LLC · Orono, MEN5302RTrinque Robert L Trustee · Plymouth, MAN5302SHazelip Jason A · Harrodsburg, KYN5302THoak Edward C · Hummelstown, PAN5302VSniader David J · Miami, FLFirst renewal noticeN5302XFnb Flying Club LLC · Gallatin, TNN53032Sutton Aircraft Salvage LLC · Palmer, AKN53035International Air Services Inc Trustee · Carson City, NVN53036Aviation Gt Inc · Wilmington, DEN53037Mb Airworks LLC · Palmetto Bay, FLN53039Laurel Highlands Aeronautical Academy · Latrobe, PAN5303BConnolly Joshua K · Vero Beach, FLN5303EQuinn George F · Amherst, NHN5303FSpaulding Kevin P · Mc Bain, MIN5303JGulf Coast Aviation LLC · New Orleans, LAN5303QWest Prairie Aircraft LLC · Weiner, ARN5303TMorey Airplane Co Inc · Middleton, WIN5303XRedemption Inc · Kodiak, AKN53044Trophy Down LLC · Punta Gorda, FLN53045East Hill Flying Club Inc · Ithaca, NYN53046Tucker Thomas G · Dillingham, AKN5304BJ & B Aviation · New Martinsville, WVN5304DDelta Enterprises LLC · Kasilof, AKN5304EDornink Farms LLC · Freeport, ILN5304FHurt J William · Hachita, NMN5304NHotrod Aviation LLC · Fayetteville, ARN5304RSouthern Arkansas Univ Tech · Camden, ARFirst renewal noticeN5304TR Gerald Hough III · Mount Morris, ILN53053Taylor Jesse L · Venus, FLN53054Ott Robert · Medina, OHN53055Echo Lake Air LLC · Soldotna, AK
Back to AD 79-10-14 R1