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.
N5967PAlsup Alan D · Gainesville, TXN5967WZillah Heights Cherry Growers LLC · Zillah, WAN5967ZMitchell Thomas F · Freehold, NYN59683Gleason Franklin R · Darlington, SCN5968DGrand Lake Air Ventures LLC · Celina, OHN5968HSlaughter Don Wayne · Farmville, NCN5968PJsm Crop Consulting LLC · Bayard, NEN5968QChess House LLC · Canton, SDN5968WDalken Dustin A · Fairhope, ALN5969DLynn John E · Fairborn, OHN5969QAbdelsalam Moustafa Gamal · Buena Park, CAN596DKShoup Douglas L · Ludington, MIN596FAOcala Aviation Services Inc · Ocala, FLN596HPAtl Pilot LLC · Senoia, GAN596MTMiddle Tennessee State University · Murfreesboro, TNN596NDSilverhawk Aviation Academy LLC · Caldwell, IDN596PHOtt Juston E · Newton, ALN596PSLester Thomas C · Anaheim, CAN596RVEagle Eye Aero LLC · Carencro, LAN596SGerondale Gerald G · League City, TXN596SCSpartan Education LLC · Tulsa, OKN596TCWinyah Aviation LLC · Wilmington, DEN5970BBlake Terry L · Saint Clair, MIN5970PJimenez Eleazar Jr · Moreno Valley, CAN5970QYeager Robert Allen · Oregon City, ORN5970UThatcher Jay C · Helena, OHN5970WBlessing Randall L · Lebanon, PAN5971DHenderson Donald G · Bedford, INN5971LLetourneau University · Longview, TXN5971URegistered aircraftN5971WGoede Mark D · Wildwood, MON5971ZFlight World Inc · San Juan, PRN5972CPyler Stephen R · North Myrtle Beach, SCN5972DAufderheide Flying Service Inc · Dewitt, ARN5972FFulhage Eric D · Yates Center, KSN5972HCastonguay Donn H · West Cornwall, CTN5972UToporkova Kamila E · Whitewater, CAN5973PSp Quality Leasing Inc · Wshngtn Ct Hs, OHN5973QFarias Gerardo M · Panama City Beach, FLN5973SPeck David T III · Whiting, NJN5973WValant Group Inc · Valrico, FLN5973ZMorrisette Roland G III · Griffin, GAN5974HWarden Robert A Jr · Ordinary, VAN5974LFifer O Lynn · Woodstock, ILN5974PWilliams Robert A · Akron, OHN5974QTaylor Timothy T · Quitman, ARFirst renewal noticeN5974SGulf Coast Aviation LLC · New Orleans, LAN5974UW8s Enterprises LLC · Stillwater, OKN5974ZFarris Kevin · Monroe, GAN5975HWilcox Darrol A · Nenana, AK
Back to AD 81-18-04 R2