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.
N2020VHunter Hallock · Waynesville, NCN2020ZAbrahamson Nicholas P II · Grosse Ile, MIN2021KJinkins Robert Lee · Silver Springs, MDN2021ZMclean Jr Rufus C · Rockingham, NCN2023MWild Gerry R · Lehighton, PAN2023YCassero Ronald V · Santa Rosa, CAN2025KByler Michael Jay · Mocksville, NCN2025ZVgh Holdings LLC · Wilmington, DEN2026KGibboney Scott H · Temecula, CAN2026NTre Aviation Corp · Wilmington, DEN2026VSzura Jeffrey S · Peoria, AZN2026ZIrons Gregory B · Nixa, MON2027YBarnhouse Vicki L · Hurricane, WVN2028EHintson John L · Pleasant Grove, ARN2028HAustin Christopher L · Waxahachie, TXN2028KHokuf Erik L · Bemidji, MNN2029VSttm Texas LLC · Spring Branch, TXN2029YFox Matthew H · Stony Brook, NYN202ENemer-Kaiser Daniel A · Eagle Point, ORN202RPLombard R Bruce · Georgetown, TXN202SHHoskins Samuel R · Murphysboro, ILN202WPStow Andrew Geoffrey · Peoria, ILN2030NShampain Noah M · South Beach, ORN2030VGleiter Jerilee A · Grants Pass, ORN2030YStetz Jeri Lynn · Pembroke Pines, FLN2031VLombard David P · Soquel, CAN2031YFluhrer Norman P · Mendocino, CAN2032BAyers Ryan · Santa Maria, CAN2032VTruex Andrew S · Peachtree City, GAN2032YBellamy James S · East Canton, OHN2032ZPointer Ned A · The Dalles, ORN2034GSchneider John B · Hardin, MTN2034YKirk Petra · Phoenix, AZN2035ACilley Sherburn C · South Royalton, VTN2035KAnderson Raymond · Grass Valley, CAN2035VReall George D · Castle Rock, CON2036ACunningham David B · Hillsboro, ILN2036NSheehan Dennis P · Addison, ILFirst renewal noticeN2036VMunoz Pedro L · Ontario, NYN2037BSilvaire LLC · White Riv Jct, VTN2037VMarshall Rodney E · Roscoe, ILN2037YArgos Retail LLC · Mcallen, TXN2038HOgren Michael W · Spring Hill, FLN2038KWalker Ray A · Sanger, TXN2039MGeissler Henry · Webster, MNN2039NFremont Aviation Inc · Fremont, NEN2039ZBradberry Charles G · Iowa Park, TXN2040KSchnelker William A · Fort Wayne, INN2040MWest Lowell A · Mocksville, NCN2040ZCreech Daniel B · Chewelah, WA
Back to AD 94-05-05 R1