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.
N714HPTic Aerospace Inc · Miami, FLN714KLMatera Management LLC · Spanish Fork, UTN714LAReese Cassidi A · Grand Forks, NDN714MDPittsburgh Pilot Training LLC · Bethel Park, PAN714NDUniversity Of North Dakota · Grand Forks, NDN714SWMackin Robert M · Castro Valley, CAN714TCJt Air LLC · Luling, LAN714TESale Reported · Molino, FLSale reportedN714TMVetter Brent E · Helena, MTN714VJones Stephen C · Wadsworth, ILN714VWMoore Harry L · Richardson, TXN71501Boone William G · Orland, CAN7150KEmerson Bryan T · Willow, AKN7150LHouston Lewis · Albuquerque, NMN7150PPickerill Robert L · Hopkinsville, KYN7150SGabrial Aviation LLC · New Berlin, WIN7150WLutter James L · Gann Valley, SDN7151GRoadrunner Flight School LLC · Farmington, NMN7151JLenticularis LLC · Madison, WIN7151RBirnschein Daniel J · Watertown, WIN7151UGendrich Charles P · Middletown, CTN7151VDakota Ear Nose & Throat Clinic Pc · Green Bay, WIN7152BKing Robert · Brush Prairie, WAN7152DWiese David · Ash Grove, MON7152GJ&B Aircraft Leasing LLC · Lufkin, TXN7152LGaither David G Executor · Houston, TXN7152QSkyrealms LLC · Austin, TXN7152YRing Petros A · Hoboken, NJN7153HGlaser Donald L III · Troy, MON7153PKnutson Daniel T · Lodi, WIN7153USmith Coty C · The Colony, TXN7153VTamadon Farhad F · Chino Hills, CAN7153WClearview Flying Club Inc · Westminster, MDN7153ZCarson Cubs LLC · Yelm, WAN7154GJuranich William M · Kent, WAN7154WBeller Construction & General Contracting LLC · Lewiston, IDN7154ZCopper River Airmotive LLC · Copper Center, AKN7155DTetzlaff Christian D · Athens, GAN7155LWright David M · Winchester, CAN7155NQualitair LLC Trustee · MichelstadtN7155QValley Ltd Of Fayetteville · Fayetteville, NCN7155RVander Ploeg Robert · Sebring, FLN7155UProtze Mark · Anacortes, WAN7155WHillsboro Aero Academy LLC · Hillsboro, ORN7155YSheasley George · Eagle Creek, ORFirst renewal noticeN71563Treml Edward I · Kewaunee, WIN7156BJstream Lc · Sheridan, WYN7156DWilliams Eron T · Overbrook, KSN7156LExcalibur Aviation LLC · Amelia Court House, VAN7156PWeinzapfel Joe M · Muenster, TX
Back to AD 87-10-06 R1