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.
N76JEReedy Dana J · Columbus, INN76JGSublett Farms · Ardmore, ALN76JKKrajewski Jason · Portland, ORN76JMWalton Daniel · Schaumburg, ILN76JRWeiner Lupita A · Mineola, TXN76JVLeonardo David · Hollister, CAN76JYYoder Jeremy L · Sarasota, FLN76KCCulhane Mark E · South Windsor, CTN76KDSchneider Aaron J · Chugiak, AKN76KFRegistration Pending · Grenada, MSRegistration pendingN76KRSorensen Bjarne K · Vero Beach, FLN76KSSchroepfer Ken J · Pecatonica, ILN76LCHacienda Hills Skyhawk LLC · Laveen, AZN76LMPavlovich Martin · Menomonee Falls, WIN76LNHillsboro Aero Academy LLC · Hillsboro, ORN76LYYonge Laurie W Jr · Oklawaha, FLN76MBHolt Helicopter Inc · Uvalde, TXN76MKMelbourne Flight Training LLC · Melbourne, FLN76MLDunn Courtland E Jr · West Grove, PAN76MMRichardson John H · Monticello, NMN76NATri Flying Tigers Inc · Wilmington, DEN76NCDonald K Ashley · Bradenton, FLN76NKNaples Jet Management LLC · Naples, FLN76NNSale Reported · Middletown, OHSale reported, canceledN76NPCollins Shannan S · Justin, TXN76PFRodriguez Amable Omar · Hialeah, FLN76PPGround Effect Aviation LLC · Ogden, UTN76PQBoyd Benjamin L · Kila, MTN76PTMcmurtrey Michael · Farmington, MNN76RMMj Aero LLC · College Station, TXN76RSCocke James A · Clarendon, TXN76RVVandevort Lynn A · Manitowoc, WIN76RWThomas Allen C · Willow, AKN76SBAdams Simmie A · Bealeton, VAN76SHConrad Edgar · Mc Alpin, FLN76SLLarsh Steven S · Libby, MTN76SRTangipahoa Mosquito Abatement District # 1 · Hammond, LAN76SSNorth Texas Aeronautics LLC · Burleson, TXN76SWHendricks Blair · Charleston, SCN76TAAhlhorn Travis W · New Braunfels, TXN76TCCox Thomas R · Kirkland, WAN76TDWillmott Wilson R · Huntington Station, NYN76TJBais Tim · Escondido, CAN76TRSwaney Mark J · Oxnard, CAN76TXBrenner Kurt · Saint Ann, MON76UDAlf Ix LLC · Chicago, ILN76VAHartzell Propeller Emp Flg Club · Piqua, OHN76VMSwartz Aviation Group LLC · Argyle, TXN76WLBuckel Joseph T · Ellison Bay, WIN76WNCorben David Meyer · Lafayette, IN
Back to AD 81-18-04 R2