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.
N4730MLovley Forrest T · Jordan, MNN4730TEgge Danny C · Pelican Rapids, MNN4730XDawson Allen J · Wshngtn Ct Hs, OHN4732HRuhnke Phil A · Grangeville, IDN4733EBecker Mark · Bismarck, NDN4733TMacneil David · Clarkston, WAN4734TSmiley Mark R · Baden, PAN4734XMclennon Daniel C · Boynton Beach, FLN4736TLb Aero Services Inc · Poplar Grove, ILN4737HEgrass Gary S · Mcgrath, AKN4737MConsalvi James V · Denver, CON4737TFly Buys Inn · Wilmington, DEN47382Paxson Christopher G · Colton, CAN4738EDetert Bradley · Valparaiso, INN4738XHageness Todd A · Rugby, NDN4739MJones David E · Looneyville, WVN4739XKimberly Jack L · Shippensburg, PAN4740MTheobald Jesse L · Colstrip, MTN4741EDemars Dale Anthony · Remer, MNN4741HMelin Jeff C · Kenmare, NDN4742XMurphy Chong Yi · Fernandina Beach, FLN4743HJohnson Zachary M · Anchorage, AKN4744HMiller Jerold R · Deering, NDN4744MZenstol LLC · Carmi, ILN4745EScott Erik G · Anchorage, AKN4745HTally Agribusiness Inc · Maryville, MON4745MDorlac Patricia E · Windsor, CON4747EMacveigh Craig A · New Carlisle, OHN4748ETaylor Aero LLC · Lewes, DEN4749HFranklin Robert D · Fort Deposit, ALN4749MHill Gary L · Minot, NDN4749XFlaat Stephen C · Bemidji, MNN4750MDreimiller Raymond J · Bloomfield, NYN47523Deaero LLC · Darwin, MNN4752HFrei Larry D · Halliday, NDN4753HAutry Lonnie E Jr · Hollister, CAN4753XUpstate Flying Club Inc · Marcy, NYN4756HWhitmore Bonnie J · Terlingua, TXN4757XFountain John D Jr · Lynchburg, SCN4758MDinstel Delbert F · Park City, MTN4759HGonzales Donald M · Columbia Station, OHN4759XBaginsky D D · Salesville, OHN475APAntcliff Monty K · Hancock, MIN475CCPerkins Mark · Athena, ORN476Webb Mark R · Delmar, MDN4761HEllis Thomas Troy · Slidell, LAN4761MSchumacher Kim L · Beach City, OHN4762HRound Rock Ranch LLC · Douglas, WYN4762XSpatiumtech LLC · Madison, ALN4765MShamrock Aviation LLC · Seabrook, NH
Back to AD 94-05-05 R1