AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N7292GMarquette 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, TXN7297JPearce 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, KSN72999Huntington 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, OHN729DRowe Perry D · Mccall, IDN729FLFlight 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, MIN729MTHochreiter Heinrich · Bellingham, WAN729NDUnd Aerospace Foundation · Grand Forks, NDN729PGGray Paul E · Elberta, ALN729RAVentura Joel · Andover, MAN729RVTwo Bag Ice LLC · Media, PAN729SKOwens Christopher · New Auburn, WIN72AEDaror Edward S · Glendale, AZN72ARDollar Douglas A · Crawford, MSN72BJRoll John K · Houma, LAN72BLSkrow Works Inc · West Monroe, LAN72BNBower Fredrick S · Watervliet, MIFirst renewal notice
Back to AD 90-04-06 R1