OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N6642UCrawford Daniel G Trustee · Dryden, MIBuilt 1963 · S/N 137N6642WBrown Kevin D · Saint Louis, MOBuilt 1965 · S/N 28-20742N6643JJohnson Steve · Attleboro, MABuilt 1968 · S/N 28-5111N6643WWeiss Stephan T · San Jose, CABuilt 1965 · S/N 28-20743N6644MSierra Lima Aviation LLC · Riverton, UTBuilt 1972 · S/N 17260503N6644ZKing Jonathan R · Palmer, AKBuilt 1950 · S/N 18-362N6645JMcdonald Neill F Jr · Fairfax, VABuilt 1968 · S/N 28-5131N6645UFreemont Investors Inc · Bainbridge Island, WAS/N 140N6645WHolman Robert S · Delta, UTBuilt 1965 · S/N 28-20745N6646HIowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1975 · S/N 17265523N6646JNoize Farm Inc · Cheyenne, WYBuilt 1968 · S/N 28-5133N6646WCordova Jesse · Raymore, MOS/N 28-20746N6647UMouton Charles J Jr · Gladewater, TXBuilt 1963 · S/N 142N6647WPanama Truck Line LLC · Florissant, MOBuilt 1965 · S/N 28-20748N6649JBowline Ray D · Salina, OKBuilt 1968 · S/N 28-5064N6649UKuykendall William · Yantis, TXBuilt 1963 · S/N 144N664FLElon Aviation LLC · Burlington, NCBuilt 1971 · S/N 28-7125586N664TJEddleman John C · White Rock, NMBuilt 1991 · S/N 664N6650JCarolian Aviation LLC · Bexley, OHBuilt 1968 · S/N 28-5076N6650ULarson Reid A · Medford, MABuilt 1963 · S/N 145N6650WCole Alexander G · Leander, TXBuilt 1965 · S/N 28-20751N6651RZucha Joseph P · Rio Vista, CABuilt 1975 · S/N MB-742N6651UWilliams Jerry L · Cortez, COBuilt 1963 · S/N 146N6652GHenehan Brendan A · Geneva, NYBuilt 1983 · S/N M-2385N6652WLumley John J · Delray Beach, FLBuilt 1965 · S/N 28-20754N6653LDempsey Christopher S · Ponderay, IDBuilt 1969 · S/N 416N6653URevisky Veronica F · Minooka, ILBuilt 1963 · S/N 148N6654FRed River Aviators Flying Club · Bossier City, LAS/N 28-7715173N6654HBertapelle Joseph R · Derby, KSBuilt 1975 · S/N 17265525N6654UHarbison Aerospace LLC · Whites Creek, TNBuilt 1963 · S/N 149N6654WKosko Stanley G · Seattle, WABuilt 1965 · S/N 28-21279N6655HDonner Ronald W · Northfield, MNBuilt 1994 · S/N 294N6655JLaukkanen Heikki J · Camas, WABuilt 1968 · S/N 28-5139N6655PHensley George T · Telford, TNBuilt 1960 · S/N 24-1778N6655UL & L Aviation LLC · Sidney, NES/N 150N6655W5b Aviation LLC · Duncan, OKS/N 28-20757N6656APike/Kelley LLC · Eureka Springs, ARBuilt 1983 · S/N MC-792N6656JFauber Clifford W · Cincinnati, OHBuilt 1968 · S/N 28-5141N6656UFanselow Dan L · White Bear Lake, MNBuilt 1963 · S/N 151N6657JRegistration Pending · Tavares, FLRegistration pendingS/N 28-5142N6657PMiller Aaron M · Scottsdale, AZBuilt 1960 · S/N 24-1780N6657WKlienstuber James D · Yamhill, ORBuilt 1965 · S/N 28-20760N6658LChump LLC · Bridgman, MIS/N 421N6659JDuffey Albert J · Clover, VABuilt 1968 · S/N 28-5146N6659RGarn Darrell L · Palmetto, GABuilt 1974 · S/N MB-743N6659UHempy David · Lexington, KYBuilt 1963 · S/N 154N6659WJeffrey Franklin B · Suisun City, CABuilt 1965 · S/N 28-20762N665DPPflum David R · Roscommon, MIBuilt 1970 · S/N 28-5817N665DWGc General Aviation LLC · Madison, NJS/N 18-7709090N665GAFlight Club 502 Inc · Louisville, KYBuilt 1977 · S/N 17268912
Back to AD 80-04-03 R2