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.
N5363KMission Aviation Training Academy · Arlington, WAN5363LTeehee Max L · Searcy, ARN5363SOwens Scotty · Crofton, KYN5363YThompson Frank L · Weiser, IDN5363ZClover Park Technical College · Lakewood, WAN53646Fhas LLC · Cassopolis, MIN5364ABradley Flying Association · Peoria, ILFirst renewal noticeN5364KAir S&T LLC · San Juan Capo, CAFirst renewal noticeN5364POwens Flight Training LLC · Lafayette, LAN5364WCowell Clayton R · Garvin, OKN5364ZHughes Tony W · Irmo, SCN53651Christiansen Aviation LLC · Wilmington, DEN5365HVyfvinkel Frederick J · New Smyrna Beach, FLN5365PLarsen Roy E · Placerville, CAN5365QWelborn Mark · Boonville, NCN5365SGamm Stephene Wade · Warrenton, VAN5365WPugh Harrison B · Tallahassee, FLN53663Iron Shield Aviation LLC · Fort Pierce, FLN5366FGoodrich James · Jacksonville, MON5366HShannon Harry D · Bartow, FLN5366JSlipstream Aviation LLC · Calera, ALN5366KAmerican Patrols Inc · Midland, TXN5366LDurnal William H · Washington, NCN5366MHillsboro Aero Academy LLC · Hillsboro, ORN5366PGreenlaw Russell C · Livermore, CAN5366WM & S Aviation LLC · Lebanon, MON5367FBlackburn Kenneth P Trustee · Dubuque, IAN5367HWingsleasing LLC · Wichita, KSN5367LMiller Grady F · Kingsland, TXN5367PBerg Robert M · Culver, ORN5367ZAdvance Aviation Inc · Dover, DENon-citizen corporation, flight hours not reportedN5368HPacific Flight Aviation LLC · Costa Mesa, CAN5368JJones Anesthesia LLC · Arcadia, INN5368MPacific Union College · Angwin, CAN5368PHeck Paul A · Santa Rosa, CAN5368TAviation Here LLC · Lino Lakes, MNN5368WFuller Jonathan T · San Antonio, TXFirst renewal noticeN5368ZTevik Michael A · Provo, UTN5369HValdiosera Octavio · Tracy, CAN5369RArmbruster LLC · Amherst, OHN536CBZelner Gregory · Merritt Island, FLN536CMCherry Hill Aviation Inc · Freetown, INN536EREmbry Riddle Aeronautical University Inc · Prescott, AZN536GRNational Aircraft Leasing Corp · Greenville, DEN536GTNorthern Planes Aerosport LLC · Algona, IAN536JRSale Reported · Port Orange, FLSale reportedN536KSKent State University · Stow, OHN536LAhmed Ejaz DBA · Carrollton, GAN536MAWilliams Fertilizer Services LLC · Oregon, MON536MMTroyer David · Newnan, GA
Back to AD 81-18-04 R2