AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9698JWalters Max D · Lamar, MON9698LGoertz Anton O · Santa Fe, NMN9698MCiota Shane · Tucson, AZN9698SLindgren Darrell A · Lake Nebagamon, WIN9698VVermont Flight Academy Inc · South Burlington, VTN9698WCas Ltd · Swanton, VTN9699DKelly Michael J · Port Orange, FLN9699JTrevino Alberto O · Vero Beach, FLN9699SBaumann Matt · Chewelah, WAN9699UDoll Electric Co Inc · Murphys, CAN9699VPiercy Danille Marie · North Bay Village, FLN969AAFlight Path LLC · Egg Harbor City, NJN969AVPiper Aircraft Inc · Vero Beach, FLN969BCCohen Brad · Palm Harbor, FLN969DBBristol David W · Sautee Nacoochee, GAN969DGDelta Sierra Avia Inc · West New York, NJN969DMFlying Cracker LLC · Wilmington, DEN969DRReeder Don W · Rathdrum, IDN969ERWooten Dudley R · Dimmitt, TXN969EZCommand Air LLC · White Salmon, WAN969FHoke Mitchell · Boulder, CON969FGMustang Sally Aviation LLC · Camden, SCN969FRWheatly Andy · Hedley, TXN969GFSky West Aviation Inc Trustee · Albuquerque, NMN969JHJls Aviation LLC DBA · Fredericksburg, VAN969JSSwanstrom John Trustee · Santa Rosa, CAN969LAJackson Aviation Of South Georgia LLC · Thomasville, GAN969LTUniversity Of La System DBA · Ruston, LAN969MGRas Aviation LLC · Elyria, OHN969MHPureflight Aviation Training LLC · Newberg, ORN969NDUniversity Of North Dakota · Grand Forks, NDN969QLindbergh Aviation LLC · Linden, MIN969RAFox Valley Technical College · Oshkosh, WIN969RRDodson International Parts Inc · Rantoul, KSN969SDThompson James R · Warren, OHN969SHDominguez Philip · Brooklyn, NYN969SPB R S Leasing Inc · Wilmington, DEN969TALola Cattle Co LLC · Rio Grande City, TXN969TTSmoketown Flight Center LLC · Smoketown, PAN969WCTexas State Aviation · San Marcos, TXN96ANCostabile Gregg D · Baker, FLN96AWPlanenutz LLC · Deland, FLN96BConservative Three LLC · Taft, CAN96BTAnema Daniel W · Groveland, CAN96BZBerencsi Tibor C · Edison, NJN96CMCarson Sundance Lucas · Canyon Lake, TXN96CWHarger Aviation LLC · Richmond, TXN96DCVertical Horizon Aviation LLC · Sandown, NHN96DLDurashok LLC · Panama City, FLN96DSAldea Da40 LLC · Summerville, SC
Back to AD 81-18-04 R2