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.
N7142LEshuis Hermannus A · Lake City, FLN7142PCorbets Jeffrey B · Santa Clarita, CAN7142QObymachow Richard M · Killingworth, CTN7142UBykowsky Eric · Atlanta, GAN7142VTarantino Joseph A · Daytona Beach, FLN71431Klele John M · Midland, MIN7143FKnoth Kurt A · Grand Haven, MIN7143GAllen Nathanael W · Bemidji, MNN7143PKc Flyers Inc · Wilmington, DEN7143RWertz Travis F · Richland Center, WIN71444Rushville Flying Club Inc · Rushville, ILN7144DRichardson James G · Fremont, CAFirst renewal noticeN7144GJc Flight Inc · Wilmington, DEN7144LN7144l LLC · Sealy, TXN7144PAllis Frederick M · Eden Prairie, MNN7144RSkyview LLC · Omaha, NEN7144VJs&J Enterprises LLC · Sapulpa, OKN7144WDornink Kent · Preston, MNN7145PAstraeus Lc · Evanston, WYN7145RBozinoff Kenneth K · Palmer, AKN7145WZhelez Alex · Deer Park, WAN7145ZSkyberg Jeffrey A · Circle, MTN7146GHalladay Roy · Erie, CON7146PRichardson Eeseh A G · Loganville, GAN7146QPressley Aviation LLC · New London, NCN7146RGrider Gary W Jr · New Boston, TXN7146WWhitford Nathan · Brunswick, OHN7147LFletchair Inc · Comfort, TXN7147UCurtin Matthew T · Cedar Hills, UTN7147YLee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYN7148Prescott Scot · Alburgh, VTN7148AHillsboro Aero Academy LLC · Hillsboro, ORN7148QRosevelt Jane · Lake Oswego, ORN7148UN192ag LLC · Mckinney, TXN7148WNorden Robert · Tappan, NYN7149DGuerin Donna N · Woodville, ALN7149LBell Larry B · Albuquerque, NMN7149RPayne William R · Old Forge, NYN7149UBas Part Sales LLC · Greeley, CON7149VLeghorn Aero Services LLC · Waynesboro, VAN714AKHartt Andrew F · Millinocket, MEN714ASSantos Andres A · Barranquitas, PRN714BGWatts Perry J · Monte Vista, CON714DBradtke Jonathon · Springfield, MON714DYChamberlain Phillip Lee · Lake Charles, LAN714EDKirkland Stephen M · Winston Salem, NCN714EYStevens Matthew S · Penn Yan, NYN714FLFather John 77 Flying Club Inc · Flushing, MIN714HRegistered aircraftN714HJNorth Georgia Grading Inc · Jasper, GA
Back to AD 87-10-06 R1