Registered aircraft · 72,001

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.

N200CWSkylake Adventures LLC · Geneva, OHBuilt 1994 · S/N 19017C N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042 N200DBDelta Bravo Inc · Davie, FLBuilt 1959 · S/N 24-1080 N200DFLijack World Enterprises LLC · Winter Haven, FLS/N 27-4080 N200DMLoudon Philip G · Manley Hot Springs, AKS/N 73 N200EBBretherton Carlos F · San Luis PotosiBuilt 1978 · S/N 78-31151 N200EHD & M Aviation Inc · Amelia, OHBuilt 1974 · S/N 200 N200EMHaines Erin · The Dalles, ORBuilt 2005 · S/N 90199 N200FAYanagida Kazuaki · Norco, CAS/N FA20049 N200FWNextwerk Inc · Carlsbad, CABuilt 1975 · S/N AA5B-0194 N200GLLudeke Gary Lee · Creswell, ORBuilt 2001 · S/N 22580 N200HGBallou-Crawford Terry F · Enid, OKS/N 1200 N200HMBill Keck Aviation LLC · Marlow, OKBuilt 1975 · S/N 32R-7680025 N200HUVanderhoof Chad T · Elk, WABuilt 1992 · S/N 1203 N200JHHampton Maurice R · Fayetteville, ARBuilt 2000 · S/N 25052 N200JKRuiz Victor · Roscommon, MIBuilt 1974 · S/N 28R-7435255 N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176 N200KMFabrega Teodoro A · Doral, FLBuilt 2003 · S/N 14109C N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176 N200LTTraver Larry L · Sturgis, SDBuilt 2000 · S/N LT6012000 N200MAlliance Aircraft Group LLC · Denver, COS/N H-11 N200MABas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887266 N200MBPurple Plane LLC · Granbury, TXBuilt 1972 · S/N 405-72 N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431 N200MUIslander Holdings Ltd · Fort Lauderdale, FLBuilt 1971 · S/N 78 N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PFPrimary Flight Control LLC · Fleming Island, FLBuilt 1984 · S/N 17276085 N200PJClayton Allen Heidelberg · Great Bend, KSBuilt 1997 · S/N G2001002 N200PMLansing Community College · Mason, MIBuilt 1983 · S/N 001 N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182 N200RBHollingsworth Robert D · Odessa, FLBuilt 1989 · S/N 001 N200RFRushin William J · Greenwood, INBuilt 1973 · S/N M-1457 N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210 N200STk Aviation LLC · Willow Street, PAS/N 609 N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200SXAllen Investments Aviation & Marine Inc · Fort Myers, FLBuilt 1994 · S/N 100 N200TBS&U Property Investments LLC · Wellington, FLBuilt 2023 · S/N 200TB N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200VMBaker Creek Enterprise · Townsend, GABuilt 1976 · S/N 32R-7780073 N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363 N200WCSigman Paul L · Incline Village, NVBuilt 1993 · S/N 792 N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117 N200YRSloan Cooper · Seattle, WAS/N 28-7615279 N200ZFPhillips Robert A · Saluda, NCS/N 24604 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N2010AMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N M-2066 N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177

Back to AD 87-10-06 R1