AD 77-01-01
Registered aircraft · 16,382
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:77-01-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-01-01')
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:77-01-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-01-01') 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.
N1076QExecutive Flight Institute LLC · Murrieta, CAN1076XMarston Lester J · Ukiah, CAN1077XJny LLC · Riverview, FLN1079HJaremus Kent M · Olathe, KSN1079YBoyer Jerry D · Monument, ORN107TANelson Sarah J · Anchorage, AKN10805Hill Ag-Air LLC · Pocatello, IDN1080HAll2fly LLC · Atlanta, GAN1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKN1080XFlying With Fitch LLC · Porter, TXN1082XWhitmer Ronald N · Ellsworth, KSN1089XCoastal Aviation Partners LLC · Hubert, NCN108AVDavis Robert S · Keystone Heights, FLN108HWYale Companies LLC DBA · Fishers, INN108WMMoran William J · Media, PAN1092TH4s Aviation LLC · Longview, TXN1092XNice Curtis A · Fort Myers, FLN1093XRoseville Aviation LLC · Roxboro, NCN10958Aero Quest LLC · Olive Branch, MSN1095XVillegas Miguel Angel Cuello · Weston, FLN1096TEvans Charles B · Benbrook, TXN1097THorizon Aviation LLC · Brooks, GAN1099JLee'S Sea Air Inc · Kiana, AKN109ATAguillard Robert N · Memphis, TNN109LDEast Bay Flight LLC · Alameda, CAN109RBClark William R · Anchorage, AKN10ASCrewson Gary · East Aurora, NYN10GHPeters Darvin Leroy · Meservey, IAN10PJMiller Kenneth R · Russellville, KYN1102NWorld Class Athletic Surfaces Inc · Leland, MSN1102XMarak Enterprises LLC · Galena, MON1103XHolmgren Joel A · Chisago City, MNN1104HSkydance Aviation LLC · Chesapeake, VAN1107HShurtz William W Jr · Medford, ORN1108HAdk Flying Club Inc · Ballston Spa, NYN1108XThompson Trisha L · Clearwater, KSN1109XBruno Michael J · Pittsburg, CAN110JA3mw Farms Inc · Hallock, MNN110LMGo Vertical Aviation LLC · Russellville, ALN110MSMcaleer Scott · Scranton, IAN110TNMaloney Casey · Placerville, CAN1112XArrow Flyers LLC · Englewood, CON11132Triple One 32 LLC · Sergeant Bluff, IAN1113ULeft Base Aviation LLC · Niagara, WIN1117XHarshman James M · Washington, PAN1118XKdr Avgroup LLC · Wilmington, DEN1118ZMoorhouse Mark A · Santa Fe, TNN111AEMatthews Timothy I · Belvidere, NJN111AJBergin Donald M · Ormond Beach, FLN111AZ360 LLC · Carson City, NVFirst renewal notice
Back to AD 77-01-01