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.
N545WHBledsoe Bobby H · Hot Springs, ARN545WRCumulus Aviation Services LLC · Port Orange, FLN545WWGrisham Michael H · Paulden, AZN545YCatching Freedom LLC · Bozeman, MTN545ZDornoch Services LLC · Dover, DEN5460BSkyway Inc · Wilmington, DEN5460NWylie David · Sharon Springs, NYN5460PT & C R Wing'N It LLC · Tempe, AZN5461HWhitson Johnny E · Cleveland, TXN5461KFaragallah Allan A · Garden Grove, CAN5461LClinton Lance D · Lago Vista, TXN5461PGraham Truett A · Lubbock, TXN5461RRegistered aircraftN5461SCarter Kenneth M Jr · Castle Rock, CON5461WGarvey David G · Erie, PAN5461ZReves Samuel S · Holly Springs, MSN54628Ohio State University · Columbus, OHN5462LGilbert Jason J · Oakland, MEN5462QLeading Edge Flight Academy LLC · Bend, ORN5462THebert David · Lafayette, LAN54633Warner Walter M · Willow, AKN54634Savannah Airplane Venture LLC · Myrtle Beach, SCN54635Memphis Navy Flying Club · Millington, TNN5463KRick Aviation Inc · Newport News, VAN5463LMcpherson Allen G · Batesville, INN5463WAngels Envy Aviation LLC · Denison, TXN5464Larson Margaret June · Shelbyville, TNN54646Jordao Isabella C · Oklaunion, TXN5464DJprg Aviation Inc · Orlando, FLN5464KTrend Vector Aviation International Inc · Barrigada, GUN5464LKelly Michael J · American Fork, UTFirst renewal noticeN5464PDanig Aviation LLC · Newark, NJN5465KMonroe Pilots Association LLC · Monroe, NCN5465SSherwood Steven · Saint Louis, MON5465WCotrell Rick G Trustee · Troy, OHN54661Executive Flyers Inc · Sacramento, CAN54663Colorado Northwestern Community College · Rangely, CON54665Registration Pending · Talking Rock, GARegistration pendingN5466D5466 Delta LLC · Costa Mesa, CAFirst renewal noticeN5466LFinkbiner Gregory A · Kennesaw, GAN5466PGriffith Charles · Santa Maria, CAN5466UJasper Aviation Inc · Jasper, ALN5466ZKlempel Reuel D · Eltopia, WAN54678Aero Association Of Caltech Inc · Pasadena, CAN5467CSteamboat Springs Flying Club Inc · Steamboat Springs, CON5467LKirk Kenneth G Trustee · Sebring, FLN5467PMeyers Terry E · Galesburg, NDN5467SBlach Edmund Jerome · Nashville, TNN5467USinor Delbert D · Ozark, MON5467WGovender Sagren K Jr · Houston, TX
Back to AD 81-18-04 R2