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.

N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20SBBrillaud Stephen A · Germantown, TNBuilt 1976 · S/N 917-76 N20SCTriple S Air LLC · Atchison, KSBuilt 2000 · S/N 2678 N20SNHealy Edward · Fort Atkinson, WIBuilt 1987 · S/N 746 N20SSBurton Scott C · Henderson, NVBuilt 1975 · S/N 61P-0248-043 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 2008 N20TKVanguard Executive LLC · Elfers, FLBuilt 1987 · S/N 748 N20TLN20tl LLC · Incline Village, NVBuilt 1987 · S/N 749 N20TUClark Steven · Dade City, FLBuilt 1963 · S/N 159 N20VCDanny J Daigle LLC · Greenville, MES/N 782 N20VMHaney Kieron J · Irrigon, ORBuilt 1965 · S/N 918 N20VTRegistered aircraftS/N 899 N20WSeawind Mjw LLC · Wappingers Falls, NYBuilt 2000 · S/N 53 N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N20WTRice James L · Mckinney, TXBuilt 1982 · S/N SW01 N20XTDon Maxwell Aviation Service Inc · Longview, TXBuilt 1991 · S/N 28-0001 N20YHuckabee Jim · Amarillo, TXBuilt 2000 · S/N 545320292FB N20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708 N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002 N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41 N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888 N21018Vega Aircraft LLC · Arcadia, OKBuilt 1978 · S/N 32R-7887186 N2101EV1 Aviation LLC · Englewood, COBuilt 1978 · S/N 17271155 N2101FVaughan Bradley C · Truckee, CABuilt 1978 · S/N 32R-7987064 N2101GCarter James E · Thornville, OHBuilt 2004 · S/N T18208230 N2101TTraylor John M · Helena, ALBuilt 1971 · S/N 28R-7135045 N2101UVansurdam John R · Seneca, SCBuilt 1961 · S/N 147 N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471 N2101XScofield Bruce W · Batavia, NYBuilt 1972 · S/N 17701785 N21027Noomen Excavating LLC · Currie, MNBuilt 1978 · S/N 32R-7887187 N2102BGillen Diesel Aviation LLC · Dania Beach, FLBuilt 1978 · S/N 32R-7985011 N2102CGreat Northern Aircraft Inc · Griffith, INBuilt 1978 · S/N 28-7916130 N2102EBrooks Terry A · Shelby, NCBuilt 1978 · S/N 17271156 N2102RLarosa Vincent · Asbury, NJBuilt 1969 · S/N 28-5461 N2102SJericho Air LLC · Hilton Head Island, SCBuilt 1979 · S/N 32R-7985085 N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663 N2102YDotzler Richard L Jr · Harlan, IABuilt 1979 · S/N 28-7911144 N21030Aircraft Management Group Inc · Honolulu, HIBuilt 1978 · S/N 28-7816529 N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890 N2103JTaffet Jay · New Orleans, LABuilt 1978 · S/N 28-7911073 N2103MMontgomery William A · El Paso, TXBuilt 1977 · S/N 28R-7837066 N2103UCramm Raymond Eduard · Palmdale, CABuilt 2005 · S/N 18281660 N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450 N2103XBrandon Capital Group Inc · Leland, MIS/N 32-7940084 N2104NHammond Brian R · Lincoln University, PABuilt 1979 · S/N 28-7990271 N2104TAllison Jack A · Orangevale, CABuilt 1971 · S/N 28R-7135048 N2104UVeracy Aviation LLC · Arlington, VABuilt 1979 · S/N 28-7990327 N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444 N21052Registered aircraftN-number assigned, not yet registeredS/N 28-7916023

Back to AD 87-10-06 R1