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.
N3388ZPuckett Keith A · Syracuse, KSN3389KKaufman Bruce A Trustee · Elm Grove, WIN338BAAardema Robert J · Kalamazoo, MIN3390JVandyke Dennis C · Rose Hill, VAN3390KFowler Darrel D Trustee · Las Vegas, NVN3392HWilliams Robert B · Azle, TXN3392NStraight Gary D · Wasilla, AKN3393KAnderson James · Saint Onge, SDN3393NPiper Aviation Museum Foundation · Lock Haven, PAN3395JFly N Style · Parkland, FLN3395KWoxof LLC · Advance, NCN3396VHarvey Christopher J · Port Leyden, NYN3397JZwerko Sherri · South Plainfield, NJN3398HSanderson Donald J · Mckinney, TXN3398KStahl Brad · Jackson, CAN339FLDalzell-Settles Lauren Executrix · Owensboro, KYN33AMStandefer Wayne B · Italy, TXN33BHPulliam Joe S · Greenville, MSN33BTWilliams David A · Whitewater, WIN33DPB&C Cejka Real Estate LLC · Sioux City, IAN33HKBarker Gerald E · Weymouth, MAN33JTTuchscherer James D · Waterloo, IAN33JZPlitnick Donald R · Port Charlotte, FLN33KYBurnette Ric A · Sebastian, FLN33PRude David L · Raleigh, NCN33TCAviation Safety Services And Management LLC · Grapevine, TXN33UEstep Justin E · Turkey Creek, KYN33WMMarshall Jerry · Hachita, NMN33YFrequent Flyer LLC · Manasquan, NJN3400VLanier Gary L · Bloomington, ILN3401CRegistration Pending · Denver, CORegistration pendingN3402BPittsburgh Insititute Of Aeronautics · West Mifflin, PAN3404DAnderson Thomas R · Seattle, WAN3405JRichmond Consulting LLC · Blanding, UTN3406JScholle Joseph E · Mustang, OKN3406KBarnstormer Aeroplanes Inc · Wilmington, DEN3407DThaxton Todd J · Williamson, GAN3408EJacobs Paul L · Huntsville, ALN34093Nuss David A · Cortland, OHN3409JMountain Home Oasis LLC · Albuquerque, NMN340JJAmnr LLC · Shawnee, OKN3410CGreer Jack D · Gillette, WYN3410DGuillory Dan Jr · Eunice, LAN3410JNewsom Rickey D · Springfield, ARN3410KKnefley Michael · Ulysses, PAN34117Hammond Neil K · Manhattan, KSN3411DBox 4-S Ranch Inc · Pullman, WAN34124Brown Lawrence W · Milo, MEN34128Verduin William D · Zeeland, MIN3412DBerens Brian T · Homer, AK
Back to AD 94-05-05 R1