AD 2000-26-16
Registered aircraft · 2,663
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:2000-26-16')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-26-16')
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:2000-26-16') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-26-16') 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.
N1099MSavery Creek Holdings LLC · Dixon, WYN1099WTop Hand Inc · Laurel, MTN109EADegiarde Robert P · New York, NYN109LLLewis & Lewis Equipment LLC · Dodge City, KSN109MLJerry Luttrell And Associates Inc · Kearney, MON109TYFly Wide LLC · Lewes, DEN10LFive States Holdings LLC · Helena, MTN10LJHarris Michael V · Wildwood, MON10NNK&L Air LLC · Lakewood Ranch, FLN10PWAircraft Partner Holdings Inc Trustee · BerlinN1100GKcd Enterprises Inc · Bartlesville, OKN1107UBeech Air LLC · Carolina Beach, NCN1108N08n Inc Trustee · Wilmington, DEN1108WEtemadian Ali · Upland, CAN1114JWarren Shelburne Michael · Chattanooga, TNN1114XAlyeska Aero LLC · Wilmington, DEN1115ZBurks Rickey D · Boerne, TXN1116AMaher Thomas J · Charlotte, NCN1116ZBear Harbor Aviation LLC · Polson, MTN1119TBest Transportation Inc · Newark, NJN111PCWright Aviation LLC · Molalla, ORN111WWMcentire Bobby Kent · Cedar Park, TXN111ZWBarker David W · Birmingham, ALN1120CBuckley Dennis P · Pawleys Island, SCN1122YD&P Beech Aviation LLC · Concord, CAN1122ZK A Lafferty Inc · Cape May, NJN1123VLizarraga Tony Claude · Truckee, CAN1127JG36 Holdings LLC · Sioux Falls, SDN1128TMccauley Mcdonald Investments Inc · Eastover, NCN112MHJsi Contractors Inc · San Antonio, TXN1130QHedges William S · Algona, IAN1134ABeaver Creek Aviation LLC · Clinton, OKN1134WAbs Aviation LLC · Cleveland, TNFirst renewal noticeN1134XWard Bernard Holman III · Wichita Falls, TXN1136ARegistered aircraftN1136NPga Re LLC · Midland, TXN1136PBjmj LLC · Greensboro, NCN1136SBig Sky Beech LLC · Red Oak, IAN1136VN1136v LLC · Sheridan, WYN1136YBonanza Aviation Inc Trustee · Wilmington, DEN113AWMontana 1 LLC · Missoula, MTN113JTAerotransplant Inc · Marfa, TXN11421Beach Prairie LLC · Cedar Rapids, IAN1157TSalloom Mary M · Gaithersburg, MDN116BDTxbd Investments LLC · Addison, TXN1178TDavis Aviation Group LLC · Gastonia, NCN1179TQuad Rabbit Inc · Wilmington, DEN117ECRambana & Ricci Pllc · Tallahassee, FLN1184JD&D Chessies LLC · Wilmington, DEN118TBColtman Peter O · Colleyville, TX
Back to AD 2000-26-16