Registered aircraft · 72,007

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

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

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.

N272ACFlying Radish LLC · Vineyard Haven, MABuilt 1998 · S/N 1253-98 N272AFEarly Roy W · Beaver, PABuilt 1988 · S/N 5146 N272BDDanby James D · High Rolls, NMBuilt 2001 · S/N 001 N272BSHes Aircraft LLC · Auburn, ALBuilt 2018 · S/N 41714 N272CSkythrills! LLC · Fullerton, CABuilt 1974 · S/N 20-01 N272CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881006 N272CCFarkas Jordan C · Anchorage, AKBuilt 2001 · S/N 9925CC N272CPPetracca Carmine O D · Lewiston, IDBuilt 1983 · S/N 272 N272DBBrock Dean R · Hawthorne, FLBuilt 1973 · S/N 17261821 N272DKKroutil David W · Hilmar, CABuilt 1978 · S/N 17271857 N272DRMiller Seth A · Sahuarita, AZBuilt 1985 · S/N 272DR N272ECBurchett Michael · Bettendorf, IABuilt 1981 · S/N 28-8111081 N272FBlanchard Aviation LLC · Waynesboro, GABuilt 2014 · S/N 73080 N272FDFly Dynasty Corp · Ocala, FLBuilt 1968 · S/N 28-24693 N272GBaudouin Dameries · Pagosa Springs, COS/N 27-4189 N272GTNfh Aviation LLC · Pikeville, KYS/N 44-7995054 N272HWHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020272 N272JAGold Coast Aviation LLC · Oxnard, CABuilt 1976 · S/N 17267439 N272KMHickman Michael G · Longmont, COBuilt 1997 · S/N 5003 N272KSOlson Richard · Eau Claire, WIBuilt 1967 · S/N 28-23936 N272LCPen And Pilot Inc · Flagler Beach, FLBuilt 1972 · S/N 28R-7235059 N272MGAircraft Evolution LLC · Miami, FLBuilt 2016 · S/N 2434 N272MLRegan Michael E · Bend, ORS/N 14072C N272RARomeo Alpha Flyers Inc · Nashville, TNBuilt 1974 · S/N 17263700 N272RRGray Kerry · Monterey, CABuilt 1973 · S/N 17261914 N272SDVigneault Leonard J · Southbridge, MABuilt 2018 · S/N 71662 N272SGLehner Raymond A Jr · North Fort Myers, FLBuilt 2004 · S/N 969-2004 N272TWillis Patrick A · Eugene, ORBuilt 1995 · S/N 21 N272TCMiller Ralph · Fleming Island, FLS/N 001 N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272VXSpence Lorne J · Saint Cloud, FLBuilt 2019 · S/N 140272 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N272ZMarson Richard W · Eagle River, AKBuilt 1998 · S/N 1050 N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033 N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202 N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034 N2733KRegistered aircraftBuilt 2006 · S/N 40517 N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032 N27349Valley Airways Inc · Scottsbluff, NEBuilt 1977 · S/N 31-7712087 N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042 N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043 N2736SVmc Development Inc · Sanger, TXBuilt 2020 · S/N 81921 N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036

Back to AD 87-10-06 R1