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.
N73GInternational Air Services Inc Trustee · Carson City, NVN73GBBotsford Glenn J · Cudahy, WIN73GSHill Gregory A · Romeo, MIN73GTJordan James P III · Folsom, CAN73HUFx Consulting Ltd · Washington, OKN73HYDenniston Tom · Sherwood, ARN73JFFreeburg John D · Fruitland, IDN73JGMeyer Gordon W · Huber Heights, OHN73JTRegistered aircraftN73KLTanych Tyler · Inverness, FLN73LMKrueger Carl R · Put In Bay, OHN73LNHelzer Jarrod · Antioch, CAN73MDReed Henry J · Jacksonville, NCN73MHRainier Flight Service LLC · Renton, WAN73MMPuddle Jumper Aviation LLC · Brighton, CON73MRMarshall Edward G Trustee · Saint Clair, MIN73MSJohnson Kevin N · Bethpage, NYN73NEBeshaler Ag Inc · Arnold, NEN73PAJones Brandon B · Saint Francisville, LAN73PDToribio LLC · San Antonio, TXN73PFSinor Delbert · Ozark, MON73PPArew Aviation LLC · San Tan Valley, AZN73PWWarren John M · El Paso, TXN73RZBas Part Sales LLC · Greeley, CON73SSchulze Craig W · Burbank, CAN73SDMedlock-Turek Patick Evan · Clifton, NJN73SHEaton Michael J · Killen, ALN73STClearskys Aero LLC · Seneca, SCN73TAWorks Design Group Inc · Hammondsport, NYN73TDWeber Michael Scott · Gonzales, LAN73TLTeaff Leslie T Trustee · Russellville, ARN73TSWeene Michael L · Moultonborough, NHN73VPyle Dana · Naples, FLN73VMSecurcloud LLC · Castleton, NYN73WGGlattli William H · Boynton Beach, FLN73WRStanton Fred H · Amherst, NYN73ZFlying Rocks LLC · Sparkill, NYFirst renewal noticeN7400DSmith Dwight S · Ann Arbor, MIN7400KLopez Lionel A · Wasilla, AKN7400RHambey Eric M · Walnut Grove, MON7400SHutter Charles G · Carson City, NVN7400YWright Amos L Jr · Enterprise, ALN74024Milner Stephen L · Dallas, TXN74026Coburn William E · Carrollton, VAN74027Harvey James R · Ocala, FLN7402RReynolds Gary W · Forest, VAFirst renewal noticeN7402VKendrick Brian S · Kerrville, TXN7402YN5746u LLC · Dover, DEN7403JMejia Ramirez Martin E · Perth Amboy, NJN7403KAnderson Jeff · Lewisville, NC
Back to AD 81-18-04 R2