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

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.

N521ASStanz John Trustee · Maple City, MIBuilt 1982 · S/N 32R-8229051 N521AWUrban Equipment LLC · Vineland, NJBuilt 1971 · S/N 31-765 N521CBHodge Cleo U · St Thomas, VIBuilt 1962 · S/N 2304 N521CWCentral Washington Univ · Ellensburg, WABuilt 2017 · S/N 2843922 N521DDUrbana Aviation LLC · Woodstock, OHBuilt 2002 · S/N 40.215 N521DHPenner Ford Aviation LLC · Lebanon, MOBuilt 1965 · S/N 28-21007 N521DMAllison James R · Middlefield, OHBuilt 1972 · S/N 17260567 N521DZSchultz Charles J · Juneau, AKBuilt 2012 · S/N 3147 N521EEMhg Leasing LLC · Edgewood, KYBuilt 1979 · S/N 27-7954067 N521ER521er LLC · Blaine, MNBuilt 2001 · S/N 172S8924 N521FCStevens Kole · Sebec, MEBuilt 2008 · S/N 001 N521GTNeptune Skies LLC · Little Elm, TXBuilt 1974 · S/N 17262819 N521JDH&G Farms Inc · Corcoran, CABuilt 1998 · S/N 172S8027 N521KGSimpson Joseph E · Knoxville, TNBuilt 2024 · S/N 42203 N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519 N521LDStar Marianas Air Inc · Tinian, MPBuilt 1977 · S/N 17269184 N521MWGruetzmacher Marcus Collin · Denton, TXFirst renewal noticeBuilt 1960 · S/N 24-1978 N521RLCherry Creek School District No 5 · Greenwood Village, COS/N 0216 N521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636 N521TKCato Air LLC · Wilmington, DEBuilt 2005 · S/N 18281673 N521TRRizzo Anthony M · Winter Haven, FLS/N DMO379 N521TTCaras Tiger LLC · Homestead, FLS/N 10128 N521TYRegistration Pending · Olympia, WARegistration pendingBuilt 2023 · S/N M5-5-9M5/10M5-5018 N521XPalmetto Aces Flying Club LLC · Hilton Head Island, SCBuilt 1978 · S/N 28-7911038 N52200Pol Guillermo L · Miami, FLBuilt 1980 · S/N 17274433 N5220AMarshall Chadwick J · Fort Walton Beach, FLBuilt 2002 · S/N 18281149 N5220BFolbre Frank S · Millsap, TXS/N 1083 N5220LR & J Services LLC · Tracy, CABuilt 1967 · S/N 28-4513 N5220PStancil Thomas E III · Winterville, NCBuilt 1958 · S/N 24-247 N5220RChaz L Enterprises LLC · Ringwood, NJBuilt 1974 · S/N 17263434 N5220THammond Michael R · Tigard, ORS/N 28-7225360 N5220WHosemann Aaron · Riverview, FLBuilt 1961 · S/N 28-257 N5220XCartwheel Aviation LLC · Boise, IDBuilt 1992 · S/N 694-92 N5220YHart Robert D · The Villages, FLBuilt 1962 · S/N 27-2269 N52210Pressly Joel D · Sunriver, ORS/N 24129 N52217Mustang Sally Aviation LLC · Camden, SCBuilt 1980 · S/N 17274441 N52218Jej Leasing LLC · Bangor, MEBuilt 1980 · S/N 17274442 N52219Warren Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274443 N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778 N5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514 N5221RDunaway Jeffrey W · Bremerton, WABuilt 1974 · S/N 17263435 N5221S3a LLC · Trussville, ALS/N 32-40915 N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258 N5221XVandegrift Robert W · Waynesboro, VABuilt 1969 · S/N 200 N52220Meyer Jeffrey K · Osceola, WIBuilt 1980 · S/N 17274444 N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456 N5222GHanger C16 LLC · Pinckney, MIBuilt 2002 · S/N T18208164 N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738 N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249 N5223MGraham Holdings Inc · Atherton, CANon-citizen corporation, flight hours not reportedBuilt 2002 · S/N 20608180

Back to AD 87-10-06 R1