OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N3640NShaikh Samir K · Schaumburg, ILS/N 680021N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253N3640XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 348N3640ZElliott Frank F · Mojave, CABuilt 1960 · S/N 22-7535N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73N36417Huber Weylin L · Aberdeen, SDBuilt 1973 · S/N 575-73N3641NVilliger Arnold H · Henry, ILBuilt 1967 · S/N 680022N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514N3642MCraig James P · Jacksonville, ARBuilt 1947 · S/N 12-2497N3642PSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1955 · S/N 22-3393N3642QPorte Elvis · Miami, FLS/N MB-262N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73N3643MKing Jay M · King Salmon, AKS/N 12-2496N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023N3643XBurbey Mark G · Racine, WIS/N 301N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663N3644PHanselmann Seth · Lincoln, VTFirst renewal noticeBuilt 1955 · S/N 22-3395N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518N3647KRayman Bethany A · Salem, SDS/N 28-23666N3647PHubbard Robert Thomas · Atlanta, GABuilt 1955 · S/N 22-3398N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667N3648ZMow The Sky LLC · Midway, UTBuilt 1960 · S/N 22-7545N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519N3649PHelmer Daniel W · Eagle, AKBuilt 1955 · S/N 22-3400N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776N364HKoberg Lance L · Dallas, GABuilt 1974 · S/N 364N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364N3650RScd Medical LLC · Alexandria, LABuilt 1969 · S/N 28-5747N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025N3653PWright Michael · Hurricane, UTS/N 22-3404N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522N3656PKennedy Lukas · Anchorage, AKS/N 22-3407
Back to AD 80-04-03 R2