Registered aircraft · 54,015

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.

N8349UMassey Jay C · Mineral Wells, TXBuilt 1964 · S/N 17252249 N8349XRoberts Thomas Randy · Amarillo, TXBuilt 1961 · S/N 17248849 N834GTIlmberger Stephen R · Sisters, ORBuilt 1981 · S/N 15285111 N834ZGroshel Joseph C · State College, PABuilt 1955 · S/N 32038 N8350APhillabaum Stephen D · Deer Park, WABuilt 1952 · S/N 25202 N8350BTatum Travis · Gatesville, TXBuilt 1957 · S/N 36150 N8350JSustarich Stephen M · Ketchikan, AKS/N 15066250 N8350SRegistration Pending · Wheatland, CARegistration pendingBuilt 1965 · S/N 18256450 N8350UColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17252250 N8350XLee Daryl P · Poplarville, MSBuilt 1961 · S/N 17248850 N8351JRkd Aviation Services Inc · Dallas, TXBuilt 1967 · S/N 15066251 N8351LPlane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256551 N8351MWheaton Eric J · Gig Harbor, WAS/N A1500051 N8351TLazic Nina · Wilmington, OHBuilt 1962 · S/N 17557051 N8351URappa Colin C · Nazareth, PAS/N 17252251 N8351XSky Rangers Inc · Stockton, CAS/N 17248851 N8352AWood Jeremy D · Girdwood, AKBuilt 1952 · S/N 25204 N8352BRoark Larry W · Wheatland, INBuilt 1957 · S/N 36152 N8352JByrds Wholesale Inc · Clayton, NCS/N 15066252 N8352LFielding David · Scarborough, MES/N 17256552 N8352MOak Ridge Flyers Inc · Oak Ridge, TNBuilt 1969 · S/N A1500052 N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213 N8352SMacwilliamson Roger · Hollister, CABuilt 1965 · S/N 18256452 N8352UVirani Shamshuddin · Fayetteville, GAS/N 17252252 N8352XSchmid William J · Anchorage, AKBuilt 1961 · S/N 17248852 N8353BRodriguez Antonio M · Presidio, TXFirst renewal noticeBuilt 1957 · S/N 36153 N8353GHove Jeffrey P · Saint Paul, MNBuilt 1965 · S/N 15062453 N8353XAcme Racing LLC · Overland Park, KSBuilt 1961 · S/N 17248853 N8353ZMccoy Jesse Jacob · Cabot, ARBuilt 1963 · S/N 205-0353 N8354BTri Flight LLC · Cottonwood, MNBuilt 1957 · S/N 36154 N8354LEast Texas Imperial Petroleum LLC · Flint, TXBuilt 1968 · S/N 17256554 N8354SNorthrop Kimberlei A · Spokane, WABuilt 1965 · S/N 18256454 N8354UErvin Jerome · Lometa, TXBuilt 1964 · S/N 17252254 N8354XWillow Equip LLC · Fox River Grove, ILBuilt 1961 · S/N 17248854 N8355BBowen Jeffrey N · Jacksonville, NCBuilt 1957 · S/N 36155 N8355GGrant Jimmy L · Ada, OKBuilt 1965 · S/N 15062455 N8355JPadilla Hector F · Mountain View, CABuilt 1967 · S/N 15066255 N8355MRcs Services LLC · California, MDFirst renewal noticeBuilt 1969 · S/N A1500055 N8355QDelta Pacific Northwest LLC · Anchorage, AKS/N U20603216 N8355SFayette Hawks Flying Club Inc · Somerville, TNBuilt 1965 · S/N 18256455 N8355TDakota Aircare Inc · Wagner, SDBuilt 1961 · S/N 17557055 N8355UWilhelm Joshua Robert · Lake Havasu City, AZBuilt 1976 · S/N 15077925 N8356AClinard Larry L · Escanaba, MIS/N 25208 N8356ESky West Aviation Inc Trustee · Albuquerque, NMS/N 17272192 N8356MSporie George F · Marinette, WIBuilt 1969 · S/N A1500056 N8356SHirlinger Saylor John Trustee · Stevenson Ranch, CABuilt 1965 · S/N 18256456 N8356UKolb Austin R · Phoenixville, PABuilt 1964 · S/N 17252256 N8357AMcclellan Richard G · Poplar Grove, ILBuilt 1952 · S/N 25209 N8357BHarker James P · Blaine, MNS/N 36157 N8357KBaldasaro Bonnie B · Clifton Park, NYS/N 15070575

Back to AD 87-20-03 R2