AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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.
N7290JPiper Nicolas A M · Atherton, CAN7290PFarmland Investments Inc · Mound City, MON7290VChristen Aviation LLC · Pawnee City, NEN7291DLehman John Thomas · Corbett, ORN7291FTusing Richard C · Newell, SDN7291GKuntz Jeffrey A · Covington, OHN7291JCenterline Equipment Corp · Waukegan, ILN7291PHenris Air LLC · Onsted, MIN7291WKiser Eugene A · Sheboygan, WIN7292FAalderks 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, OHN7294PMcnamara Pa · Far Hills, NJN7294WCapstone Aviation LLC · Lancaster, CAN7294YTgaap Inc · Dover, DEN7295GHessel Block Co Inc · Hessel, MIN7295JHaass Susan D Teese · Cypress, TXN7295QKangas Lisa M · Fairbanks, AKN7296GWind Walker LLC · Tucson, AZN7296QRich Aviation Services LLC · Fort Worth, TXN7296ZKolb Duane L · Bison, SDN7297JPearce Jim R · Stratford, TXN7297LFehr Jacob · Grand Forks, NDN7297WTurner Joseph N · Chuckey, TNN7298FAgostini Joseph L · Broomall, PAN7298JNapper Kenneth L · Sacramento, CAN7298WSchnitiker Allan A · Pratt, KSN7298ZShenandoah Valley Soaring Inc · Nellysford, VAN72999Huntington Roger · Galena, AKN7299FGardner Todd D · Poland, INN7299QStout 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, IDN729FLFlight Adventures Llp · Pleasant Grove, UTN729GABradley Mark S · Holly, MIN729JPunton Robert P · Ayr, NDN729JHDickman Robert J · Richmond, INN729KTThompson Kenneth A · Caledonia, MIN729MNCool Springs Consulting Inc · Cocoa Beach, FLN729MTHochreiter Heinrich · Bellingham, WA
Back to AD 87-10-06 R1