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.
N561TFAir Fleet Holdings LLC · Missoula, MTN561TPKerner Christine A · Yelm, WAN561ZDelgado-Ocasio Brunilda · Patillas, PRN56201Kaney Howard W · West Bend, WIN56202Kunze Paul C · Tempe, AZN56204Andreas Charles V · Neenah, WIN5620LRichardson Carl · Jonesboro, GAN5620QMorgan Josiah B · Owasso, OKN56211Bergstrom Aircraft Inc · Pasco, WAN56213Elite Florida Ac LLC · Titusville, FLN5621QOwens Ronald W · Newburgh, INN5621UMeinert Kyle L · Cottage Grove, WIN5621WHurt Bret K · Huntsville, ALN56220Seashell Aviation LLC · Milton, FLN56224Thomas Way LLC · Jackson, MIN56227Registration Pending · Ira, MIRegistration pendingN5622HHallum Randal · Wewoka, OKN5622KAyorinde Olawale T · Upper Marlboro, MDN5622PBaker Franklin E · Montgomery, ILN56231Leber Oliver P · Spanish Fort, ALN56239Hobart Aviation Inc · Akron, OHN5623EKd3262 LLC · Downers Grove, ILN5623GMorris Hancock Flying Club · Morris, MNN5623UMendoza Cesar · Anthony, NMN5623ZQuinlan John H · Claxton, GAN56241Smith Bonny L · Milan, INN56247Aviair Corp · Tequesta, FLN5624GFoothill Aircraft Sales & Service · Upland, CAN5624HCameron Thomas W · Lennon, MIN5624PCobb Jeremiah B · Colorado Springs, CON5624QSwanson Shawn · South Beloit, ILN56256Flying Bears Aviation LLC · Wilmington, DEN5625QFly High Aviation LLC · Margate City, NJN5625USkorina Air LLC · Walla Walla, WAN5625ZBellamy John Mark · Freeville, NYN56264Fingerlakes Aviation LLC · Marietta, NYN5626HWhitmore Martha J · Terlingua, TXN5626LMw Aviators LLC · Olathe, KSN5626QJustus League LLC · Los Angeles, CAN5626UFly Around Alaska LLC · Palmer, AKN5626WMiller Andy · Marana, AZN56277Lightfoot John A · Hagerstown, MDN5627FFolger Alfred J · Columbia, SCN5627LFrattarelli Marco · Carrollton, TXN5627UMcelhannon Susan L · Athens, GAN5627WSavio Stefan V · Trophy Club, TXN56280Briggs Samuel K · Portland, ORN56281Lewis Nathan Timothy · Hayden, IDN56282Kowatra Anil K · Lilburn, GAN56283Stephens Donald K · Modesto, CA
Back to AD 81-18-04 R2