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.
N4484LMifflintown Airport Aero Club Inc · Loysville, PAN4485EManly Dodson W · Fruitland Park, FLN4485UMapes Peter B · Oscoda, MIN4486UTaylor Roger D · Paris, TNN4487ESmith Ronald D · Anderson, INN4489BHarris Ryan A · Valley Cottage, NYN4489U237th Aero Squadron Inc · North St Paul, MNN448EMKurth Walter E · East New Market, MDN448RMichetti Matthew P · Anchorage, AKN4490BDichter Alexander · Palm Harbor, FLN44919Irvin Thomas D · Ripley, TNN4491BMessersmith David · Beaver Falls, PAN4492BParzyk Jason D · Lake Stevens, WAN4492HBryant Stephen · Anchorage, AKN4493BGridley Trevor M · Fairbanks, AKN4493EFnf Aviation LLC · Kalamazoo, MIN4494BMiller Daniel G · Seattle, WAN4494LJ&S Aviation Services LLC · Hastings, NEN4495LBlue Wings LLC · Brecksville, OHN4496UMcgraw David M · Fairbanks, AKN4497BCounsell Jon E · Snohomish, WAN4498BMorris Charles W · Wasilla, AKN4498EMyers Joe A · Rush Springs, OKN4498UN4498u LLC · Langley, WAN4499LKilo Charlie LLC · Lenexa, KSN4499UMcmahon John P · Huntington Beach, CAN44BMClark Dennis L · Ozona, TXN44DDowd John J Jr · Syracuse, KSN44DHShore Gerry · Inez, TXN44JDonovan Gerald A · Los Lunas, NMN44PForester Dwain E · Tonopah, NVN44RCPeterson Matthew W · Ethel, LAN44RPCook Aviation Services LLC · Fargo, NDN44SSEllingham Jeffrey B · Elko, GAN44VYTsi Holdco Inc · Virginia Beach, VAN4500CLynch Dana L · Fairbanks, AKN4500MBaty Russell L · Sheridan, MTN4500UButler Dale K · Hillsborough, NCN4501UPruzek Russell T · New Auburn, WIN45023New Joel · Waco, TXN45028Witke Ray · Menomonie, WIN4502CMcfarland Keith A · Oklahoma City, OKN4502MPletcher Marvin D · Yuma, CON4502UWise Joseph D · Kilgore, TXN45031Stahla Russell · Girdwood, AKN45034Coffelt Roy · Nampa, IDN45045Lingle Gordon D · Gun Barrel City, TXN4504CHickle William H · Inyokern, CAN4504EHall Nathan M · Shepherd, MTN4504MMiller John M · Newburgh, ME
Back to AD 94-05-05 R1