AD 94-05-05 R1
Registered aircraft · 26,232
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.
N7111TMesseder Thomas Alan Jr · Fredericksburg, VAN7111XGoodwin Joseph N · Grass Valley, CAN7112FHurst Richard H · Lometa, TXN7112SBridges Robert S · Friendswood, TXN7112XKoplitz Wesley D · Oshkosh, WIN71138Smithwick Patrick M Trustee · Kiowa, CON7113ATrail Richard L · Mccook, NEN7113MOgle Tyler E · Eufaula, OKFirst renewal noticeN7114FWernecke Thomas C · Southfield, MIN7114TMeyer Andrew J · Carter, SDN7114XKnutson Wayne R · Tioga, NDN7115ARothenbusch Michael G · Tampa, FLN7115MSatanta Flying Service Inc · Satanta, KSN7115T172 Club LLC · Olalla, WAN71168Butler County Warbirds Inc · Middletown, OHN7116HStarr Roger A Trustee · Canby, ORN7116TMaierhoffer Henry F · Sylvania, GAN7116XWeggel Roger · Fairbanks, AKN71179Spears Rickey L · Longmont, CON7117MFly 2 Hope LLC · Hilliard, FLN7117TOrtega Rolando J · Davie, FLN7117XBoldog Sandor Alex · Andalusia, ALN7118GRegistration Pending · Spruce Pine, ALRegistration pendingN7118SSanders John B DBA · Knoxville, TNN7118XRosier Wayne C · Lexington, NCN7119AMcfarland Michael G · Seabeck, WAN7119FCossette Bradley J · Detroit Lakes, MNN7119HGravesen Chad · Atlanta, GAN711BPProsser Robert A · Statesboro, GAN711CSHodack Steven J · Burton, MIN711DCDufford Michael W · Alpine, CAN711DRAntique Aircraft And Automobile LLC · Van Alstyne, TXN711EFoushee Michael J · Columbus, INN711LMPowell Sherman B · Pulaski, TNN711MTaddeo Annie M · Punta Gorda, FLN711SNSkywatch Aviation LLC · French Village, MON711WFSmith Lot P · Grangeville, IDN7120TDelauder Patrick J · Terra Alta, WVN71212Smith Brian D · Sinclairville, NYN7121ARoberts Calvin D · Bluebell, UTN7121FMartin Tricia · Tulsa, OKN7121TSiscoe Ronald D · Bloomington, INN7123AMerchant Herbert M · Powhatan, VAN7123TDevalcourt Randall · Washington, LAN71245Kussatz Michael · Olathe, KSN7124MNelson Daniel G · Meadow, SDN7124TCaskey Jessica B · Anchorage, AKN7125FWerner Angela S · Grand Forks, NDN7126AFreeman Michael D · Morgantown, INN7126MDarling Charles R · Albany, OR
Back to AD 94-05-05 R1