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.
N7881WEast Crest Management LLC · Eastvale, CAN7882CKeck Joseph S · Las Vegas, NVN7882PWaters Robert D · Albuquerque, NMN7882VSlepian Isaac J · El Dorado Hills, CAN78830Frederick Wayne Schultz · Bradley, ILN78834Barron Ted L · Hoover, ALN7883DMeierotto Marty · Two Rivers, AKN7883PFinke Michael C · Pleasant Prairie, WIN7883VFranks Gary E · Ponder, TXN7883WStack Brian James · Paso Robles, CAN7883YHoward Jerry W · Snellville, GAN78842Helice Sarcelle LLC · San Antonio, TXN78846Aero Investors Lc · Jackson, MIN78850Karpik Richard Paul · Grand Rapids, MNN78856Bedwell Christopher A · Paso Robles, CAN78857Hunt Thornton Trevon · Aurora, CON7885DLindstrom Daniel G · Somerset, WIN7885WCp Authority LLC · Poulsbo, WAN7885YKregel Steven · Garnavillo, IAN78861Wood Jeffrey A · Willis, TXN78865Gingras Carl A · Avondale, CON78869Zullo Thomas L · Lindenhurst, NYN7886GArctic Barnabas Ministries Inc · Kenai, AKN7886VLowenhaupt Michael J · Metairie, LAN7886WChelena Eric D · San Antonio, TXN78871Rosenfeld Kristina M · Eureka, CAN78873Mesner Steven M · Tomah, WIN78875Janssen Christopher R · Ankeny, IAN78877Obrien Garrett G · Sheep Ranch, CAN7887GLandrum Erik · Austin, TXN7887P7887papa LLC · Glenwood Springs, CON7887WDepp Gregory B · Ft Worth, TXN7887YAskins Jack C · Wichita Falls, TXN78880Coma Aviation LLC · Buckhannon, WVN78882Triplat Bonnie E · Rosamond, CAN78884Cooke Daniel S · Kanarraville, UTN78888Woodard Ben C · Truckee, CAN7888MMonpas Mark E · Anderson, CAN7888WLashinski Michael J · Monument, CON7888YBurkel Robert G · Hemet, CAN78890Edmondson Donald M · Harvest, ALN78891Registered aircraftN78892Rathbun Robert E · Maywood, MON78893King Eugene A · Rch Palos Vrd, CAN78894Gonzalez Francisco C · Biloxi, MSN78897Knox Phillip A · Snellville, GAN78898Clawson Michael · Allentown, NJN7889GFricker Mark W · Avon, INFirst renewal noticeN7889PWalker Zachary R · Burlington, NDN7889VPoorman Christopher · Burleson, TX
Back to AD 87-10-06 R1