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.
N7022WHall Wesley B · Hot Springs, ARN7023PHanna Trenton W · Lakeland, FLN7023QHudson Valley Flight LLC · Wappingers Falls, NYN7023RPushpull LLC · Montgomery, TXN7023VJackson William G · Clinton, MDN7023YMaki Stephen B · New Port Richey, FLN7024BNelson Daniel D · Omaha, NEN7024PAnderson Richard · Dickson, TNN7024QWells Nathan S · Scotia, NEN7024TCorrigan Joseph M · San Marcos, CAN7024USpitzer Helicopter LLC · Woodland Hills, CAN7024YAnderson David J · Gardnerville, NVN70256Winn Edwin F · Louisville, KYN7025CDowning Gregg R · Guymon, OKN7025ELyon Emery F · Welsh, LAN7025PA Precious Life Flight LLC · Bend, ORN7025USchultz Walter J · Pine Beach, NJN7025WBerberich Edward C · Gillette, NJN7026DSfcaa LLC · Nashville, TNN7026MLoerzel Loren · Blair, NEN7026RSanderson Eric R · Chelan, WAN7026UWilliams Mike C · Sonora, TXN7026WAdvanced Aviation Inc · Lakeville, MNN70275Christiansen Aviation LLC · Wilmington, DEN7027DHuriburt Ward · Dillingham, AKN7027QAero B Flying Service · Richards, MON7027UTtwn Media Networks LLC · New York, NYN7027VJohnson Marvin D · Gilbert, AZN70282Edwards Robert J · St Helena, CAN7028GKathol Donavin J · Hartington, NEN7028PNorthern Cape Sea Farms LLC · Cape May, NJN7028QBurns Michael S · Coplay, PAN7028RCuckler Jason Michael · Jenks, OKN7028WBlakely Richard S · Yerington, NVN7028YAces High Aviation Corp · Pembroke Pines, FLN7028ZQuality Aviation Inc · Marana, AZN7029RBazzi Adel · Yorba Linda, CAN7029WUSA Aircraft Leasing LLC · Dover, DEN702AWBrown Pryce R · Anchorage, AKN702BSTwo Bravo Sierra LLC · Auburn, CAN702CCRpd Enterprises Inc · Nicholson, PAN702CPCivil Air Patrol · Maxwell Afb, ALN702DBShiffer David A · Woodstock, OHN702DCTaylor Denise DBA · Lincoln, CAN702ELAerostar Transportation Systems LLC · Houston, TXN702GTsiouklas Aviation Inc · Dunedin, FLN702GPUniversal Investors LLC · Independence Chate, MIN702GRAir America Flight Center LLC · Daytona Beach, FLN702JWisdom Murrel Wade · Nashville, ARN702PGOn Three Angels Wings LLC · Melbourne, FL
Back to AD 87-10-06 R1