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.
N920ACNaples Air Center Inc · Naples, FLN920AJAmerican Patrols Inc · Midland, TXN920BEGalaxy Aviation LLC · Nantucket, MAN920BTThorpe Brian J · Saint Augustine, FLN920BWWilliams Rebecca J · Alto, NMN920CJJones Alva L · Craig, CON920CPCivil Air Patrol Inc · Maxwell Afb, ALN920EPEpic Aviation Inc · New Smyrna Beach, FLN920ERSunrise Aviation · Ormond Beach, FLN920GBales Don · Oakhurst, CAN920GDAir Charter Inc DBA · Culebra, PRN920GTBeauchesne Harold J · Enterprise, ALN920HGGreco Robert J · Overgaard, AZN920HWWikstad Herulf L · Nevada City, CAN920JCTrabold Jeffrey G · Kingsport, TNN920JLBaxley Aviation LLC · Baxley, GAN920KBarker Andrew Robert · Portland, ORN920LHHatley Byron J · Sparks, NVN920MAPerry Castonguay Farms Inc · Omega, OKN920MSWaco Safe Flyers LLC · Robinson, TXN920MTAcron Aviation Academy Inc · Sanford, FLN920NCState Of North Carolina · Raleigh, NCN920PHYetiskin Kenan · Huntsville, ALN920SBDream Cloud Aviation LLC · Saint Marys, PAN920TAAtp Aircraft 4 LLC · Wilmington, DEN920WBJet Air Inc · Iowa City, IAN92103Pgd Flyers Inc · Cape Coral, FLN9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9210HFlex Air Holdings Inc · Wilmington, DEN9210LMid Atlantic Air Museum · Reading, PAN9210MHahn David · Port Lavaca, TXN9210NShapiro Sarah Keck · Indianapolis, INN9210SBazemore Dennis A · Ingleside, TXN9210VHarrison Joe · Atlanta, TXN9210WSmith Brian · Mechanicsburg, OHN9210XMills Anthony D · Midland, MIN92115Stanger Joseph E · Willow, AKN9211CClark Michael J · Grapevine, TXN9211JBrown Herbert R · Halls, TNN9211MSowers James Dalton · Park City, KYN9211VMorrissey Thomas A · Peachtree City, GAN9211WRockwell Tracey W · Atlanta, INN9211ZSchacht Michael A · Torrance, CAN9212CMyers Kenneth O · Niskayuna, NYN9212JJones Greg E · Thomasville, GAN9212LSmith Randall G · Salem, ORN9212VKocher Edward A · Longview, TXN9212WProws Anthony · Othello, WAN92131Cavu Flyers Of Long Island Inc · Ronkonkoma, NYN9213EHolman Michael · Wasilla, AK
Back to AD 81-18-04 R2