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.
N811ZRhoads Timothy C · Logan, NMN81202Pray Aviation Inc · Augusta, KSN8120BGreat Northern Aircraft Inc · Griffith, INN8120FPray Aviation Inc · Augusta, KSN8120JCope Christopher J · Plumas Lake, CAN8120MMckissick John R · Westminster, MDN8120PLysford Troy D · Dalhart, TXN8120XMccool Kenneth Wade · Olive Branch, MSN8120YDevries Dennis J · Owasso, OKN8121BVolkmann James P · Bellingham, WAN8121FKraack Stephen T · Lithia, FLN8121JSchluckebier Daniel C · Aldie, VAN8121KRegistered aircraftN81223Eat Aviation LLC · Metter, GAN81227Grumman Aviation LLC · Virginia Beach, VAN8122BErwin Mark N · Snyder, TXN8122CJordan Walter B · Chehalis, WAN8122HSchlesinger Richard J · West Cornwall, CTN8122PDamico Anthony J · Riverview, FLN8122QN8122q LLC · Venice, FLN8122WRoberts Barry R · Aurora, CON8122ZCrosswinds Flying Club Inc · Bloomington, ILN81237Registration Pending · Austin, TXRegistration pendingN8123CTurlock Fruit Company Inc · Turlock, CAN8123WHoke Todd D · Hilton Head Island, SCN8124ADakota 7 LLC · Kirkwood, MON8124JBulluck Martha C · Apex, NCN8124MSale Reported · Hollister, CASale reportedN8124QMn Badger Aviation LLC · Rochester, MNN8124SBauso Kenneth · Marfa, TXN8124YMatthews Grover C · Hardinsburg, KYN81250Sanchez Paul K · Boca Raton, FLFirst renewal noticeN81251Winfield John F Jr · Scituate, RIN81259Thermodynamic Sciences LLC · Irvington, ALN8125ANt-Cfp LLC · Baltimore, MDN8125DBas Part Sales LLC · Greeley, CON8125LHillsboro Aero Academy LLC · Hillsboro, ORN8125PIrie Lot LLC · Westminster, CON8125WLynch Ronald · Carson City, NVN8125YGlass Jody L · Indianapolis, INN81260Trusty Archer LLC · Ann Arbor, MIN8126DHackleman Brian K · Rochester, NYN8126EAnderson Wilbur W Trustee · Lead Hill, ARN8126MWest Hawaii Wingers Incorporated · Kailua Kona, HIN8126PCsm Holding LLC · Boscobel, WIN8126XB2fh Ltd · Allentown, NJN8127Quimby James N · Bay City, TXN81274Elhaje Tamim · Cypress, TXN8127DTrimmer Marvin E · Willow, AKN8127EFugate Ruth · Riverside, CARegistration revoked
Back to AD 87-10-06 R1