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.
N3994SAugustus Aircraft LLC · Whitefish, MTN3995JWoodstock Air LLC · Monticello, FLN3995LLee Valerie A · Newville, ALN3995TCorlett Thomas I · Clinton, WAN3995VDesjardins James H · Troutdale, ORN3996JThorman Joseph · Moorhead, MNN3996SNavarro Herbert R · Flagstaff, AZN3996UGiguere David P · Kingwood, TXN3996VShiver Gary C · Zolfo Springs, FLN3997Shippers Michael S · Williamson, NYN3997EStrahan Ronald R · Girard, KSN3997SJazc LLC · Doniphan, NEN3997VWestfall Lorn W III · League City, TXN39982Brown James A · Fairbanks, AKN3998EOchsenbauer David J DBA · Ashland, WIN3998LKansas Copters & Wings Inc · Augusta, KSN3998UAlbrecht Koby J · Lawrence, MAN3998VDoornbos Keith · Bloomington, ILN39999Becker Kurt G · Dexter, NMN3999JMurphy Arthur John III · Huntsville, ALN3999LMorris Jeffrey A · Lake Delton, WIN399CCEagle River Ranch LLC · Hermiston, ORN399EFisher James W · Humboldt, TNN399STLankford Austin S · Sturtevant, WIN399TXCherry Lane R · Vidor, TXN39DNDavis Steven C · Bishop, CAN39DTAloof Joseph N · Dunnellon, FLN39JJStag Aviation LLC · Tomball, TXN39LSchababerle Mark J · Cincinnati, OHN39LBWhitaker Ian S · Orange, CAN39LMPhillips William R · Cullman, ALN39TDHawk Meadow Aviation LLC · Sutton, AKN39TRRapp Timothy · Fairfield, MTN39XDHall Thomas D · Monrovia, CAN3AEMcknight Jerry W · Centerburg, OHN3DHHaig Dennis A · Andover, KSN3EVDuncan John C · Gastonia, NCN3FKSumrow James O · Madison, OHN3GDNadh Development LLC · Santa Rosa, CAN3HLLamarr Ryan A · Greenview, CAN3JTMcdannel Albert M · Laporte, INN3NHFord John P · Loudon, NHN3PVAtkinson Russell M · Concord, CAN3RJB&B Transport Inc · Omaha, NEN3TMSea-Air Ltd · Aurora, ORN3WALebaron Timothy J · Midland, VAN3XZStrom Laurelin · Lexington Park, MDN3ZFBussey Charles E · Chouteau, OKN4000FDe Lisio Frederick C · Andover, MAN4000NSanchez Sebastian · Albuquerque, NM
Back to AD 94-05-05 R1