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.

N32HYRunzel Brothers Aviation LLC · Bensenville, ILBuilt 2000 · S/N 2102N32JBHeimat Corp · Lincoln, NEBuilt 1971 · S/N 473N32JLSanson William P Jr · Dodge Center, MNBuilt 1967 · S/N 28-4391N32JMMiller Biplane LLC · Moberly, MOBuilt 1973 · S/N JM001N32JVChrapczynski Daniel T · Sheffield Village, OHBuilt 1993 · S/N M-II-001N32KAFowlkes Preston L · Marfa, TXBuilt 2002 · S/N 2193N32KHN32kh LLC · Quincy, WAS/N 287790384N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454N32LSPerhach Andrew J · Seattle, WABuilt 1989 · S/N 1208N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023N32NCEcho 7 Systems LLC · Lewes, DEBuilt 1999 · S/N 21989N32QXSpacewalker 2 LLC · Ocala, FLS/N 32091N32RVTimbie Peter W · Palatka, FLBuilt 1997 · S/N 22253N32SAAmoretti Remor Vinicius · Gardena, CABuilt 1977 · S/N 28-7725174N32SHFuller Jon A · Goliad, TXS/N 0599N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199N32WTEdwards Anthony C · Weaverville, CABuilt 1990 · S/N 1495N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862N32YBHjelle Mark L · Barrett, MNBuilt 2000 · S/N 80613N33000Sindlinger Lyle · Puyallup, WABuilt 1971 · S/N HH-1N33001Peak Builders Inc · San Diego, CAS/N 28-7525134N3300PDiscover Resources LLC · Norman, OKBuilt 2003 · S/N 90275N3300ZKoliastasis Pete · Reno, NVBuilt 1959 · S/N 22-7231N33017Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515289N33018Lovingier Michael J · Glendale, AZBuilt 1975 · S/N 28-7515290N3301PDramstad Flying Service LLC · Helena, MTBuilt 1958 · S/N 23-1251N3301ZWood Paul S · Lawton, OKBuilt 1959 · S/N 22-7232N3302DGeorge Clifford E · Starkville, MSBuilt 1997 · S/N 3302N3302ZMeginnes Mark A · Tucson, AZS/N 22-7234N33030Fanopoulos Joshua J · Boise, IDS/N 28-7525139N3303ZZanis Paul M · Wolfeboro, NHBuilt 1959 · S/N 22-7233N33046American Eagles Flying Club · New Hudson, MIBuilt 1975 · S/N 28-7505114N3304BDoty Danial J · Talkeetna, AKBuilt 1956 · S/N 22-2119N3304PBucket List Aviation LLC · San Jose, CABuilt 1958 · S/N 23-1254N3305PAir Royal · Middletown, DEBuilt 1958 · S/N 23-1255N33061Piper 33061 LLC · Rustburg, VABuilt 1975 · S/N 28-7505116N33064Facklair LLC · Granville, OHS/N 28-7505117N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498N33077Klug Ryan Gregory · Lincoln, NEBuilt 1975 · S/N 28-7525149N33079Devaney Aviation Inc · Palm City, FLS/N 28-7525150N3307PAlbano James R · Oakham, MAFirst renewal noticeBuilt 1958 · S/N 23-1257N33081Tofan Ray · Chula Vista, CAS/N 28-7505119N33083Barnhill Chris · Carbondale, ILBuilt 1975 · S/N 28-7505120N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153N3309JMomentum Foundation · Tullahoma, TNS/N 15066009N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241N330ARegistered aircraftBuilt 1954 · S/N 22-1939N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884
Back to AD 80-04-03 R2