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.
N7292FAalderks Roger H · Blomkest, MNN7292GMarquette County Flying Club · Marquette, MIN7292JCapital Region Aviation Partners Inc · Troy, NYN7292QDevereaux Bruce O · Pewamo, MIN7292XRasmussen Paul L · Walla Walla, WAN7293JFuller Jaime E · Walnut Cove, NCN7293LHeilade204 LLC · Jupiter, FLN7294JForsyth Matthew J · Fayetteville, GAN7294LHampshire Kimberly S · Piqua, OHN7294WCapstone Aviation LLC · Lancaster, CAN7294YTgaap Inc · Dover, DEN7295GHessel Block Co Inc · Hessel, MIN7295JHaass Susan D Teese · Cypress, TXN7295QKangas Lisa M · Fairbanks, AKN7296GWind Walker LLC · Tucson, AZN7296KVne LLC · Sheridan, WYN7296QRich Aviation Services LLC · Fort Worth, TXN7296ZKolb Duane L · Bison, SDN7297JPearce Jim R · Stratford, TXN7297KWarren Mark J · Sleetmute, AKN7297LFehr Jacob · Grand Forks, NDN7297WTurner Joseph N · Chuckey, TNN7298FAgostini Joseph L · Broomall, PAN7298JNapper Kenneth L · Sacramento, CAN7298KNeal Christopher C · Staples, MNN7298WSchnitiker Allan A · Pratt, KSN7298ZShenandoah Valley Soaring Inc · Nellysford, VAN72999Huntington Roger · Galena, AKN7299FGardner Todd D · Poland, INN7299KHofer Todd Paul · Doland, SDN7299QStout Oscar M · Brookshire, TXN7299WBugner David J · Savannah, GAN729ACKleptz Arlene B · Union, OHN729BWSwayze Bruce W · Molalla, ORN729CBFodor Vincent A · Doylestown, OHN729CPCivil Air Patrol · Maxwell Afb, ALN729DRowe Perry D · Mccall, IDN729EBoard Of Trustees Of Southern Illinois Universtiy · Carbondale, ILN729ELRegistered aircraftN729FLFlight Adventures Llp · Pleasant Grove, UTN729GABradley Mark S · Holly, MIN729JPunton Robert P · Ayr, NDN729JHDickman Robert J · Richmond, INN729KBTallman George L Jr Trustee · Ocala, FLN729KTThompson Kenneth A · Caledonia, MIN729MNCool Springs Consulting Inc · Cocoa Beach, FLN729MTHochreiter Heinrich · Bellingham, WAN729NDUnd Aerospace Foundation · Grand Forks, NDN729PGGray Paul E · Elberta, ALN729RAVentura Joel · Andover, MA
Back to AD 81-18-04 R2