AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N276AJCrumpton Aviation LLC · Tulsa, OKN27708Wightman Randy A · Owosso, MIN2770CGuzik James V · Lindstrom, MNN2770LAnderson Curtis Merle · Manson, IAN2770SBirk Ronald G · Wellington, NVN2770UStandard Equipment Leasing And Sales LLC · Wilmington, DEN2771CKenmore Crew Leasing Inc Trustee · Bellingham, WAN2771EBenton James A · Enterprise, ALN2771LP&N Corp · Marion, IAN2771NMeyer Corben D · Lafayette, INN2771UTobin Eric L · Cambridge, OHN2772LBell William E Jr · Summerville, SCN27732Shadwick Clarence R · Tunnel Hill, GAN2773DHattaway Gene · Double Oak, TXN2773JN2773j LLC · Titusville, FLN2773NMidwest Corporate Air Inc · Bellefonatine, OHN2774DOutbound Aero LLC · Kiowa, CON2774SPeterson Dennis · Cambridge, MNN2775KSanders Brian L · Tehachapi, CAN2775LKing Mons A · Paoli, PAN2775NSavant Rusty W · Kinder, LAN2775SRichardson Arthur · Herald, CAN2775ULuff John W · Odessa, MON2776DAtiyeh Aziz Matthew · Aumsville, ORN2776LRd Aire LLC · Opelika, ALN2776UGarrison Randy · Queen City, TXN2777CSteiner Richard D · Butler, PAN2777LHataway Gregory L · Kinston, ALN2778DBaker Julius W · Anchorage, AKN2778NDunshee Anette M · La Luz, NMN2778SStamper Brian L · Tucson, AZN2778URoberts Kenneth B · Wall Township, NJN2779DLumley Carol J · Eagle River, WIN2779LResetar Douglas J · Pittsford, NYN277CKreikemeier Terry L · Garfield, WAN277KLCoombs Johnnie · Blue Mountain, MSN277NWindh Randall · Reedley, CAN277RTGonzalez Edwin A · Scott Afb, ILN277WSKropp Christian Trustee · Azle, TXN2780CWheeler Russell E · Roxbury, CTN2780DChythlook Joseph L · Dillingham, AKN2780KNielsen Paul O · Wellington, CON2780NSparkys Flying Service LLC · Warner, NHN2780SNapolitano Frank D · Howell, MIN2781CRoark Collin P · Franktown, CON2781KAircraft Guaranty Corp Trustee · Oklahoma City, OKN2781LEllis Grover Dale Jr · Sanford, NCN2781NLacey Scott M · Morris, ILN2781SGadberry Garth · Heath, TXN2782CGideon William W · Dayton, OH
Back to AD 94-05-05 R1