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.
N2567URegistration Pending · Fort Worth, TXRegistration pendingN2568ULuce Mark E · Tucson, AZN2568VFarringer Steven R · Columbia City, INN25694Weston Scott Erb Trustee · Wasilla, AKN2569EClassic Aeroplane Club Inc · Lugoff, SCN2569JMapes Peter B · Oscoda, MIN2569UHalladay Roy · Erie, CON256NYAlexander David H · Warrensburg, NYN2570FDexter Fred H · Live Oak, FLN2570JKnutson Family Ltd Partnership 2 · Chetek, WIN2570LHerman John K Jr · Flagler, CON2571CLane Steven A · Rockwood, MEN2571DLiebsch Greg A · Gilbert, AZN2571JWullner Leeroy J · Cedar Rapids, IAN2571LClements Jim L · Cushing, OKN25727Dean James J · Sanford, NCN25730Orton Aviation LLC · Walker, MNN2573NKruger Thomas H Jr · Hoquiam, WAN2573YFritz David C · Lincoln, NEN2574DDumm Wesley J · Kodiak, AKN2574NWest Thomas L · Payson, AZN2574Y9th Moon Enterprises LLC · Alpine, TXN25753Komin Steve C · Ingleside, ILN2575DBurgess William S · Anchorage, AKN2575FAksarben Flying Club LLC · Bellevue, NEN2575JStein Gerald A · Tolar, TXN2575YSky Unlimited · Portland, ORN2576CFlying R LLC · Fruitdale, SDN2576DMarshall Jerry J · Parker, AZN2576EOlear Inc · Evansville, INN2576LRiggin Flight Service Inc · Madison, SDN2576YRowe John W · Glen Haven, CON2577JDelaney John T · Bangor, PAN2577LKim L Jensen · Enoch, UTN25786Bertrand Jarett · Funk, NEN2578CPayne Megan T · Anchorage, AKFirst renewal noticeN2578DKnuths Kristian Jacob · North Pole, AKN2578JRenewed Inc · Tekamah, NEN2578NSeanez Justin · Hollister, CAN2578YBush James W · Skaneateles, NYN2579FPalmetto Aviation LLC · Florence, SCN2579JMaatje Charles J · Egg Harbor City, NJN2579UHann Aviation LLC · Yuma, AZN25804Frazier Forrest Alan · Augusta, MON2580DPlace Ashley K · Bradenton, FLN2580JKingdom Air Corps · Sutton, AKN2581CClepper Catherine M · Saegertown, PAN2581DMccullugh Jordon T · Idaho Falls, IDN2581JStikeleather Fred A · Hiddenite, NCN2581NWise Jeffrey R · Ocala, FL
Back to AD 94-05-05 R1