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.
N6864HMay Jeffrey N · Ocala, FLN6864JHudson Phillip Jr · Cookeville, TNN6864NStensen Craig J · Mount Juliet, TNN6865AAtp Aircraft 7 LLC · Wilmington, DEN6865BEllis Ray Lynn · Lakeside, CAN6865JPlanepals LLC · Waverly, MON6865NRegistered aircraftN6865WGraves William · Highlands, TXN6865YDelaware Aircraft Trust LLC Trustee · New Castle, DEN6866HParrish Michael C Trustee · Lakeland, FLN6866NMancini Peter A · Kenmore, NYN6866PDeckard Kyle R · Harrisburg, ORN6867BMarx Nathan L · Sauk City, WIFirst renewal noticeN6867JOtmane Lahouari · Orlando, FLN6867NKnox Robert W Jr · Hazlehurst, GAN6867UMesquite Metro Flying Club · Dallas, TXN68680Willat Bret G · Warner Springs, CAN6868AFlamingo Air Inc · Cincinnati, OHN6868DFlamingo Air Inc · Cincinnati, OHN6868KFlamingo Air Inc · Cincinnati, OHN6868ZC-Fleet LLC · Missoula, MTN68690Locaero Services Inc Trustee · Wilmington, DEN6869JNa Aviation LLC · Mount Vernon, OHN6869UHostetler Kevin J · Green Forest, ARN6869WRegistered aircraftN686ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN686CACoast Flight Training And Management Inc · Dallas, TXN686JMavity Michael D · Phoenix, AZN686JAHot Wings Aviation LLC · Indianapolis, INN686JCRepublic Aircraft Leasing LLC · Ocala, FLN686LHChristiansen Aviation LLC · Wilmington, DEN686MSLauney Aviation LLC · Sacramento, CAN686NDUnd Aerospace Foundation · Grand Forks, NDN686RJEsplin Rulon Gregory · Nampa, IDN686RWBetancourt Ernest B · Lascassas, TNN686SLRatzburg Mark · Madison, WIN686SPRainier Flight Service LLC · Renton, WAN6870JCentral Minnesota Aviation LLC · Paynesville, MNN6870LBarr Air Patrol LLC · Mesquite, TXN6870PPruitt Steven W · Sioux Falls, SDN6870UTahirovic Elmaz · Sharpsburg, GAN6871JRyan Air Ventures LLC · Auburn, GAN6871PHogue Kalum Shane · Monroe, TNN6871WSkylux Aviation LLC · Coppell, TXN6872NVivian Rodney E · Cincinnati, OHN6872WMergen Andrew John · Colorado Springs, CON6873BBent James L Jr DBA · Palatine Bridge, NYN6873CMabry Roger Louis Jr · Norwood, NCN6873NWhitfield Jesse Leigh · Anacortes, WAN6873WUptegrove James L · Susanville, CA
Back to AD 87-10-06 R1