AD 94-05-05 R1
Registered aircraft · 26,230
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.
N94828Wilson Patric J · Oklahoma City, OKN94829Whitmire Ashley D · Canyon Lake, TXN9482ASnyder Kenneth C · Lonsdale, MNN9482ECuley Paul T · Wilmington, NCN9482UClark Josh D · Morehead, KYN94833Wright Jeffrey S · Pahrump, NVN94841Remmers David C · Hebron, NEN94842Brain Sidney L · Harrison, ARN94844Berens Eric A · Stevens Point, WIN94845Daniels Janet A · Omaha, NEN94848Wersland Kenny M · Sidney, MTN94849Mulhall Suzan · Lampasas, TXN9484ABrown Glen S · Aberdeen, MSN94855Gabriel Richard A · Manchester, NHN94856Seigler Larry · Sugar Land, TXN94857Abbey Ryan T · Sherwood, ARN9485ABeam David M · Sabina, OHN9485BLuggar Michael D · Leonard, MNFirst renewal noticeN9485KGregory Vernon L · Swansea, SCN94860Specht Leo M · Towner, CON94865Schutten Francis J · Kirkland, WAN94867Reynolds Terry · Phoenix, AZN94868Thompson Randal L · Redding, CAN9486ASimonson David C · Iron River, WIN94874Tillman Vadis E Jr · Hinton, OKN9487AMccown Bill · Dripping Springs, TXN9487BFord Christian G · Pasco, WAN9487UCallejo Joseph S · Port Saint Lucie, FLN94881Heusinkveld Karen B · San Marcos, TXN94886Walker Stephen L Trustee · Andover, KSN94887Moore Gary Trustee · Hillsboro, OHN94889Springer Thomas W · Gulf Breeze, FLN9488ARadke Harlow · Hastings, MNN9488UGardner Christopher · Addison, TXN94890Yeates Rebecca A · San Angelo, TXN94894Chappie Michael R · Sidney, OHN94898Gorham Raymond A · Lock Haven, PAN94899Mellon James D · Webster, WIN9489URodriguez Alonso Jr · Alamo, TXN94907Johnson Bradley Alan · Wasilla, AKN9491AWonder Aviation LLC · Nashville, TNN9491BGuess Jonathan M · Pineville, LAN9492BPack Charles · Millington, TNN9493ABrooks Charles W Jr · Hesperia, CAN9493BRowe Chad A · Fairbanks, AKN9494ASmiley Neil G · Clover, VAN9494UAirgo Inc · Centralia, ILN94958Szostak Edward M · San Diego, CAN9495BFry John W · Vinita, OKN94964Underwood Andrew R · Soldotna, AK
Back to AD 94-05-05 R1