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.
N73662Flores Francisco H · Avondale, AZN7366DMh Aviation Inc · Lancaster, CAN7366FDesantos Rance · Baldwin, NYN7366LBoles Quincy · Panama City, FLN7366PAnthony Craig D · Keller, TXN7366TJones Bruce E · Aurora, COFirst renewal noticeN7366WBatchelder Norman · Newport Beach, CAFirst renewal noticeN7366YShockley Kenlon D · Aurora, CON7366ZAerial Banners North Inc · Pembroke Pines, FLN73671Registered aircraftN7367EGregg Flying Service Inc · Durango, CON7367FDuffys Aircraft Sales And Leasing Inc · Neillsville, WIN7367JWise Dustin A · Fairbanks, AKN7367KSpivey Harold E · Thomaston, GAN7367LRegistered aircraftN7367WRapp Stephen Martin Trustee · Zephyr, TXN7367ZAerial Banners North Inc · Pembroke Pines, FLN73686Falcon Aviation Inc · Farmington Hills, MIN7368FW Tech Consulting Inc · Wilmington, DEN7368JDylan Branch LLC · Tomball, TXN7368KLahn James A · Bemidji, MNN7368LBohman John T · Monona, WIN7368NAka Fun LLC · Jupiter, FLN7368WBurkholder Earl F · Middleburg, PAN7368YHoenmans John P · Roseville, CAN7369JSmith Zachary T · Nokesville, VAN7369KRidings Dustin Eugene · Oconto, WIN7369LMcdonnel Jack E Jr · Woodsboro, TXN7369PGrier Randall · Owasso, OKN736AAHoover Brian A · Warsaw, INN736BABest Aviation LLC · Hoxie, KSN736BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN736DWGertiser Frank M · Lapeer, MIN736DZDogwood Memorial LLC · Grapevine, TXN736ERButton Duane D · Lone Tree, CON736FHoffmanns Aircraft Services Inc · Loxahatchee, FLN736HFStoklosa Michael · Miami, FLN736JBBrownell Kenneth C · Leverett, MAN736LBSkyraider Aero Club · Spokane, WAN736LFAvitran Inc · Coral Gables, FLN736MJClover Park Technical College · Lakewood, WAN736NDUnd Aerospace Foundation · Grand Forks, NDN736NGCatcu Aviation LLC · Edinburg, TXN736NJCarr Gary A · Rittman, OHN736PAConnection Leasing Co · Dallas, TXN736QUCloudstreet Partnership · Albuquerque, NMN736QXTeets Trent D · West Fargo, NDN736RAWernsman William Adam Trustee · Garnett, KSN736RGRegistered aircraftN736RMBagwell Danny A · Arley, AL
Back to AD 81-18-04 R2