OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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
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:80-04-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:80-04-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.

N8522DAdams Daryl S · Monticello, FLBuilt 1957 · S/N 22-5750N8524DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5752N8524YGasmire David C · Fredericksburg, TXS/N 18-8888N8526Core Tech Services & Supply LLC · Odessa, FLBuilt 1973 · S/N 449-73N8526FMinton Gabriel D · Wexford, PABuilt 1976 · S/N 28-7715279N8526KBaratta Richard J · Tower, MNBuilt 1956 · S/N 18-4953N8526ZRyther John W · Austin, MNBuilt 1952 · S/N 20-900N8528CJain Abhishek · Weehawken, NJBuilt 1976 · S/N 28-7615115N8528YYoung David A · Lakeland, FLBuilt 1968 · S/N 30-1689N852DAHendrix Rex · Pell City, ALBuilt 1975 · S/N 17264427N852HHoffart Paige D · Omaha, NEBuilt 2011 · S/N 81985N852NDPlane Nonsense Inc · Middletown, DEBuilt 1989 · S/N 4495006N852TStudarus John E · Sacramento, CABuilt 1974 · S/N M-1528N8530DCurcio Steve J · Oak Creek, WIBuilt 1957 · S/N 22-5758N8536DAnderson Kel G · Alta, IABuilt 1957 · S/N 22-5768N8536YEastern Flight Services Inc · Ronkonkoma, NYBuilt 1984 · S/N 0438N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73N8538DMarble Jere D · Dayton, NVBuilt 1957 · S/N 22-5769N8539DEdens Ferlin C · Boone, COBuilt 1957 · S/N 22-5770N853AKKase Gayle L · Wasilla, AKBuilt 2017 · S/N 6901N853RSOlson Helicopters LLC · Corpus Christi, TXS/N 3807N8541CHulsey Johnathan James · Wasilla, AKBuilt 1997 · S/N 999N8541EFlying Services Inc · Wilmington, DEBuilt 1984 · S/N 0442N8543DHuntwork Dayna · Boise, IDBuilt 1957 · S/N 22-5774N8543EAce Aircraft Leasing Inc · Nazareth, PABuilt 1976 · S/N 28-7625140N8544DThames James W · Florence, ALBuilt 1957 · S/N 22-5775N8545DFour-Five-Delta LLC · Mountainville, NYBuilt 1957 · S/N 22-5776N854ACKurchian Aram M · Sunland, CABuilt 1975 · S/N 17265443N854CAJunie The Flying Dog LLC · Atlanta, GABuilt 1973 · S/N 28-7415040N854HCN854hc LLC · Watkinsville, GABuilt 2003 · S/N 5704N854NDAero Equities LLC · Ventura, CABuilt 1989 · S/N 4495008N854PD139th Aeroclub LLC · Miami, FLBuilt 1978 · S/N AA5B-0854N8550DRiester Gary R · Navarre, FLS/N 22-5782N8551VTall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N 793-75N8552DSvec Adolph Ralph · Marengo, ILBuilt 1957 · S/N 22-5784N8554DParks Alan J · Homer, AKBuilt 1957 · S/N 22-5786N8556VParis Charles F · Pioneer, LABuilt 1974 · S/N 794-75N8557DWells Michael D · Wilton, MEBuilt 1957 · S/N 22-5789N8557HLloyd Davis Inc · Brackettville, TXBuilt 1985 · S/N 0460N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N855TSSteier Tim A · Blue Earth, MNBuilt 2005 · S/N 0001N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8567YJohnson Randy D · Becket, MAS/N 30-1715
Back to AD 80-04-03 R2