Registered aircraft · 54,019

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N1440GSierra-Mike LLC · Springdale, ARS/N 15072955 N1440QN1440q LLC · Maybee, MIS/N 15072740 N1440SPolkowske Leroy A · La Jara, COBuilt 1976 · S/N 18264988 N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936 N1441PN1441p LLC · Pompano Beach, FLBuilt 1973 · S/N 17260993 N1441QSale Reported · Franklin, INSale reportedBuilt 1971 · S/N 15072741 N1441SHustad Kenneth H · Spokane, WABuilt 1976 · S/N 18264989 N1441VYegge David J · Hartland, MIBuilt 1974 · S/N 17263579 N1442Viotto Stephen J · Anchorage, AKS/N 52072 N1442CMakelbust Michael J · Ames, IABuilt 1977 · S/N 17702728 N1442DBiggs James R · Piney Flats, TNBuilt 1973 · S/N 18262106 N1442MLorenzo Blake D · Wynne, ARBuilt 1975 · S/N 18264332 N1442QDelaware Aviation LLC · Sidney, NYFirst renewal noticeBuilt 1971 · S/N 15072742 N1442STodd Philip A · Wendell, NCBuilt 1976 · S/N 18264990 N1442UEastern Idaho Flying Club · Idaho Falls, IDBuilt 1976 · S/N 17267109 N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938 N1443MBahnmiller Dennis D · Highwood, MTBuilt 1975 · S/N 18264333 N1443VSchovanec David L · Stuart, FLBuilt 1974 · S/N 17263580 N1444ASocha-Leialoha John B · Bellevue, WAS/N P3370308 N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939 N1444QPelco Aviation Inc · Hampton Bays, NYBuilt 1971 · S/N 15072744 N1444SEagle Forestry Services Inc · Monticello, ARBuilt 1976 · S/N 18264992 N1444YHiggins Derrick G · Arbyrd, MOBuilt 1962 · S/N 17249144 N14455Pinkerton Matthew L · Milton, FLS/N R-172-0143 N14457Stone Kenneth R · Cedar Springs, MIBuilt 1966 · S/N R172-0120 N1445ESouth Aero LLC · Albuquerque, NMBuilt 1978 · S/N 17271004 N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940 N1445SHagemann Karl B · Santa Clarita, CABuilt 1976 · S/N 18264993 N1445YSwartz Steven L · Nashville, TNBuilt 1962 · S/N 17249145 N14460Ajkj Aviation LLC · Erie, COS/N R1720121 N1446QBeek Dudley Ernest · Miami, FLFirst renewal noticeS/N 15072746 N1446YWise Ron · Napoleon, OHBuilt 1962 · S/N 17249146 N14472Hoerler Jonathan · Lincoln, ARBuilt 1963 · S/N 18255194 N1447DSimmons Dennis L · Wichita, KSS/N 20030 N1447FCook David F · Carthage, MOBuilt 1966 · S/N 17254942 N1447SRegistered aircraftFirst renewal noticeBuilt 1976 · S/N 18264995 N1448QWjs Aircraft LLC · New Smyrna Beach, FLBuilt 1971 · S/N 15072748 N1448SWild Heart Springs LLC · Wilder, IDBuilt 1976 · S/N 18264996 N1448VGeisler Eric L · Eugene, ORBuilt 1976 · S/N R1722193 N1449EChase Matthew S · Rock Hill, SCBuilt 1978 · S/N 17271005 N1449FJanes Brenda · Shepherdsville, KYBuilt 1966 · S/N 17254944 N1449QAero Maintenance Inc · Vancouver, WABuilt 1971 · S/N 15072749 N1449UInternational Aviation Group LLC · Lake Wales, FLBuilt 1976 · S/N 17267116 N1449VLogsdon Timothy D · Livermore, CABuilt 1974 · S/N 17263586 N144ARPaone Rebecca L · South Rockwood, MIS/N 28267 N144BFHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264101 N144CRFrantz David L · Manchester, TNFirst renewal noticeBuilt 1973 · S/N 15075438 N144DRandall John R · Pearl River, LABuilt 1978 · S/N 18053001 N144JHTrachtenberg Dennis J · San Diego, CAS/N 31059 N144PWAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 17254019

Back to AD 87-20-03 R2