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.
N3934LMiller Rick J · Amherst, OHN3934VHaddock Jared · Mount Vernon, WAN3935EHoag Michael R · Three Rivers, MIN3935JMcdonald Patrick L · Ventura, CAN3935RBooher Daniel R · Humble, TXN3935SFallbrook Flight Academy LLC · Fallbrook, CAN3935UNaucler Scott N · Independence, ORN3936F36fox Aviation LLC · Branchburg, NJN3936LHeldman John M · Rawson, OHN3936RNelson Cliff A · Joplin, MTN3936UChurch Business Ministries · Greer, SCN3936VRyden LLC · Goodyear, AZN3937JWolsey Brandon S · Chino Hills, CAN3938JPlainwell Aviation And Stem Academy · Kalamazoo, MIN3938RTaylor Joseph Frank · Tamarac, FLN3938UNg Charlie K · Oakley, CAN3939JMidwest Aero Solutions LLC · Lake Saint Louis, MON3939SDream Big Aviation LLC · Mount Juliet, TNN3939VSaddler Joshua L · Lincoln, CAN3940JJess Lawrence A · Menomonie, WIN3940LLeblanc Charles A · Jacksonville, FLN3940SPrincess Air Inc · Pocahontas, IAN3940UPage Jeffrey D · Kansas City, MON3940VSoderman Brian · East Bethel, MNN3941ESadler George C · Ludington, MIN3941RDemulling Michael C · New Richmond, WIN3941VFrazier Jonas · Davie, FLN3942EErickson Lambert A · Littlefork, MNN3942FTaylor Brian · Bullhead City, AZN3942LOriginal Design Ministries · Eatonville, WAN3942ROracle Aviation LLC · Omaha, NEN3942SCromley Amanda J · Lewisburg, PAN3942VMossman Andrew D · Pickerington, OHN3943HGregory Vernon L · Swansea, SCN3943VHardman Kyle B · Shady Shores, TXN3944Avra Valley Flyers LLC · Gilbert, AZN39449Hoffman Anthony J · Rathdrum, IDN3944RFedorko Stephen J · Springdale, ARN3945LBlakesley Barrett · Spokane, WAN3945SStrickland Jason R · Tollhouse, CAN3946EWilcox Darrol A · Nenana, AKN3946FMatson William J · Wasilla, AKN3946SDepoy Lowell K · Salem, INN3947FStubbs Scott F · Tucson, AZN3947RCarter George T · Williamston, SCN3947SAir Venture LLC · Au Gres, MIN3947VCooper Charles N III · Sardinia, OHN3948SDykstra Johnny R · Sioux Falls, SDN3948UHolloway Earnie G · Bonner Springs, KSN3948VKlein Jordan Jr · Summerfield, FL
Back to AD 94-05-05 R1