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.

N1491TGreat Lakes Air Ventures LLC · Mason, MIBuilt 1972 · S/N 28-7205308 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1492TLargo Logistics LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235305 N14934Csc Delaware Trust Co Owner Trustee · Wilmington, DEBuilt 1966 · S/N 27-3178 N1493CH G Klug Sons Inc · Omaha, NEBuilt 1953 · S/N 18-2687 N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022 N1493RChaffin Alex · Fayetteville, ARBuilt 2005 · S/N 18281694 N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623 N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624 N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737 N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162 N1496CSbma Services LLC · Mcclellan, CABuilt 2005 · S/N 18281693 N1496PRobbins Warren N · Chandler, AZBuilt 1956 · S/N 23-566 N1497XTundra Toyo And Heating LLC · Nome, AKBuilt 1975 · S/N 32-7500038 N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739 N1498TMurwin Keith T · Douglasville, GABuilt 1972 · S/N 28R-7235307 N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628 N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740 N149ABVarga Miklos · Helendale, CABuilt 2005 · S/N T18208372 N149BCKurtz Garold · Mound City, MOBuilt 2004 · S/N 4532004 N149BHPylant Michael K · Huntsville, ALBuilt 2014 · S/N 1949 N149CGMoran John R · Port Saint Lucie, FLBuilt 1982 · S/N 18-8209011 N149CWMullins Jerry W · Wilmington, NCBuilt 1985 · S/N 210 N149DCDale Gared W · Hugo, OKS/N 28-2643 N149DEToma Integrity Inc · Austin, TXBuilt 2002 · S/N 90034 N149DMCraig Darrell L · Middleburg, FLFirst renewal noticeS/N 0918 N149EROhlau Mark A · Wellington, NVBuilt 1975 · S/N 1-2 N149FFountain Flying Service-Genesee LLC · Genesee, IDBuilt 2021 · S/N 5790 N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119 N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109 N149JTPanhandle Associates Inc · Guymon, OKBuilt 1986 · S/N THOMPSON 0001 N149KCLoveless Gaylan · Elaine, ARS/N 696 N149LFFord Larry M · Sebastopol, CAS/N 395 N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192 N149MAOaks Aviation LLC · Clear Lake, MNBuilt 2001 · S/N 260005 N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721 N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237 N149PCSubick Leonard · Spring City, PABuilt 1966 · S/N 27-3534 N149PRCloudbase Flyers LLC · Hillsboro, ORFirst renewal noticeBuilt 2020 · S/N 70149 N149RHHinton Scott A · Elizabeth City, NCBuilt 2007 · S/N 149 N149TMBoundless Action Sports LLC · Gilroy, CAS/N 5165 N149TSHawkins David B · Dallas, TXBuilt 2005 · S/N 81006 N149WSWexman Scott E · Port Hadlock, WABuilt 2008 · S/N 5257 N149ZBBowman Brice R · Indianapolis, INBuilt 2020 · S/N 90620 N14AEOsborn Jon C · Groveland, FLBuilt 2000 · S/N 30012C N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060 N14AXKokstis Mark D · Carlisle, IABuilt 1983 · S/N 001 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N14BFeinberg Eugene M · San Jose, CAS/N DMO 157 N14BEBelmont Circle LLC · Virginia Beach, VABuilt 1979 · S/N 28-7911322

Back to AD 87-10-06 R1