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.
N9258MJones Mavin D · Monroe, UTN9258NKma Aircraft Dream LLC · Osteen, FLN9258PCessna 79432 LLC · Missoula, MTN9258WM And T Aviation LLC · Hampstead, MDN92595Bearfight Aviation LLC · Dover, DEN9259HBooke Phillip Austin · Anniston, ALN9259JDave Flight LLC · Mccook, NEN9259PChiarini Joshua · Cranston, RIN9259RAndiamo Aviation LLC · Stonecrest, GAN9259SAlles Harry · Greeley, CON925BFSandin Robyn · Mc Donald, TNN925CBDhani Errol · Locust Grove, GAN925CPCivil Air Patrol · Maxwell Afb, ALN925DBHawk2lane LLC · Newark, DEN925DGNwi Drones LLC · Chesterton, INN925DSStarlight Technology Transfer Inc · Leesburg, VAN925EJBotsay Earl J · Diamondhead, MSN925ERCrosswell Joe D · Springtown, TXN925HEWatson James C · Boerne, TXN925JLLudwig Jerry F · West Ossipee, NHN925MHAir America Imagery LLC · Daytona Beach, FLN925MKOates Douglas E · Elgin, SCN925MML A M Capital Management LLC · Sheridan, WYN925NEriksson Kurt R · Soldotna, AKN925PASkywest Leasing Inc · St George, UTN925PBRegistered aircraftN925PTPuddle Jumper Aviation LLC · Saginaw, MIN925RHVan Belle Christopher J · San Diego, CAN925RPFriel Paul Jr · Phoenixville, PAN925RSHall Jeffrey I · Broken Arrow, OKN925TARutan Aircraft Flying Experience · Waller, TXN925TCJarvis Bradley A · North Port, FLN925TEHarris David A · Cleves, OHN925VSzelc Jerome F · Gilbert, SCN925WLCrosswind Leasing LLC · Prescott, AZN925ZKlimas David Todd · Mesa, AZN92605Sarratt Curtis H · Annapolis, MDN9260MRegistered aircraftN9260PRichter Scott J · Eden Prairie, MNN9260RVroom David H · Oro Valley, AZN9260SChristiansen Dee W · Kerrville, TXN9260TCanoace A Larned Enterprises Inc · Long Beach, CAN9260VBravo Aero LLC · Concord, NCN9260WFlo-Co2 · Gardendale, TXN92610Adventure Flight Aviation Inc · Springdale, ARN92617Stahl Raifen · Anchorage, AKN9261DBales Carson E · Wasilla, AKN9261HSchrom Frederick A · Carlisle, PAN9261JLear Steven J · Rockville, INN9261MPickett Trina M · Riverside, CA
Back to AD 87-10-06 R1