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.
N822MWPilie Louis J · Grand Island, NYN822NDUnd Aerospace Foundation · Grand Forks, NDN822PASkywest Leasing Inc · St George, UTN822PJNeary Michael John · Tuckerton, NJN822REEaton Ray · Zeeland, MIN822RVWinningham Matthew P · Prattville, ALN822SPMcarthy Carolyn M · Chatham, MAFirst renewal noticeN822TFAir Fleet Holdings LLC · Missoula, MTN822VAffection Above Aviation Inc · Yukon, OKN822WSWallace State Community College · Hanceville, ALN822WYYoung James · Chehalis, WAN822XSpickard Mark A · Carr, CON82305Akima Logistics Services LLC · Usaf Academy, CON8230EKnies Eugene W · Lebanon, TNN82318Aero Nautical Adventure LLC · Camano Island, WAN82319American Medical Emergency Serv Inc · Englewood, FLN8231AKatsaliros Pete · Jackson, TNN8231EArctic Backcountry Flying Service LLC · Kotzebue, AKN8231GRad Pouria · Camarillo, CAN8231QAvier LLC · Beverly, MAN8231SBrown Mark · Peoria, ILN82325Hutchison John · Wasilla, AKN8232CLewis M Wayne · Chandler, AZN8232NWithee Steven A · Batavia, NYN8232WR&E Stars LLC · Fairfax Station, VAN82332Euroair Consultants LLC · Vero Beach, FLN8233CAirquest Aviation Inc · Kentwood, MIN8233TEast Bay Aviators N8233t · Kalispell, MTN8233WWhelchel Denise B · Upland, CAN8233XHarris Rand F · Camas, WAN82346Ross Douglas · Front Royal, VAN8234AKt Flight LLC · California, MDN8234CNewey John M Trustee · Cameron Park, CAN8234DPiper 34d LLC · Danvers, MAN8234FJones Christopher · Bonaire, GAN8234PMartinez Carlos M · Stafford, VAN8234VInnoutaero LLC · Stockton, CAN8234WRegistered aircraftN8234YBurkey Jeffrey C · Stuart, FLN82351Stasak Michael P Trustee · Sterling, AKN82353Billingsley Lowe J · Absarokee, MTN82358Nj Zev LLC · Morristown, NJN8235CBillmeyer Jim · White Salmon, WAN8235FPage John · Stockbridge, GAN8235GSterling Colleen M Trustee · El Cajon, CAN8235PZiesman Ernest D · Henderson, NVN8235SWestern New York Flying Club · Bowmansville, NYN8235YLyons Kenneth L · Port Neches, TXN82368Williams Frank · Kerrville, TXN8236GVinton Timothy R · Whitman, NE
Back to AD 81-18-04 R2