OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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-25-02-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-25-02-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.

N202TMurray James A · Wasilla, AKBuilt 1953 · S/N 18-2316N2034NNorthstar Aviation Leasing LLC · Merritt Island, FLBuilt 1978 · S/N 15282073N203LFAction Aviation LLC · Idaho Falls, IDS/N 20-1018N203TProfota Don L · Bozeman, MTBuilt 1953 · S/N 18-2317N2043HMont Belvieu Materials Inc · Mont Belvieu, TXBuilt 1946 · S/N 7AC-4302N2045Fox Wayne G · Belle Mead, NJBuilt 1972 · S/N 1AN204STWoolery Timothy A · Maryville, MOBuilt 2001 · S/N S-94120082N204TLJones Thomas G · Clearbrook, MNBuilt 2005 · S/N 001N204TTFalkenberg Randy J · Edmonson, TXBuilt 1952 · S/N 18-2318N205TClark Stephen N · Walnut Cove, NCBuilt 1953 · S/N 18-2319N206TSchou Brice N · Thomas, OKBuilt 1953 · S/N 18-2320N2082HWalker John R · Spring, TXS/N 20-0045N208CKKarel Craig F · Filer, IDBuilt 1946 · S/N 12-569N209SAInternational Air Services Inc Owner Trustee · Carson City, NVS/N 22-8448N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N20JVVan Antwerp John · Sebastian, FLBuilt 2016 · S/N JVX201N20PRGunther Randell L · Chandler, AZBuilt 1950 · S/N 20-136N20RPPash Rand O · Harlan, IABuilt 1981 · S/N 101N20UCHeinze Gregory L · Little Rock, ARBuilt 1990 · S/N 148N20VSAce Aircraft Co Inc · Toccoa, GABuilt 2011 · S/N 82128N20WWHansen Mark T · Stuart, FLS/N 1078N2102Smith Kenneth W · Springfield, ILBuilt 1997 · S/N JHM96N210NGHarvey David S · Heathsville, VABuilt 1990 · S/N 2135N2111NLongacre John David · Anchorage, AKS/N 12347N21188Korney Stephen · Norwalk, CABuilt 1978 · S/N 38-78A0046N211WKKelley William J · Arroyo Grande, CABuilt 1978 · S/N 176N212MBEuro 2000 Inc · Merritt Island, FLBuilt 1978 · S/N 15279920N212MCLester Shane G · Council Bluffs, IAS/N 306062N212PTVann Dudley C · Greenville, NCBuilt 1978 · S/N 38-78A0800N213EZOff Road Freedom Jr LLC · Walled Lake, MIS/N 101N213GDEdal Inc · Plantation, FLBuilt 1978 · S/N AA1C0145N213MKKwiatkowski Matthew A · Minooka, ILBuilt 2008 · S/N 213N213TFlemmer Richard W · Park City, MTBuilt 1953 · S/N 18-2327N2143MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 20928N2143NSuter John R · Jacksonville, NCS/N 12379N2146MPeterson Scott W · Garfield, KSBuilt 1946 · S/N 20931N214DPRothhaar Paul M · Yorktown, VABuilt 1985 · S/N 38N214LFHorsman Dewey D Jr · Crestview, FLBuilt 2004 · S/N 20-1031N214NLLescher Richard G · Monroe, WABuilt 2019 · S/N WR293S095N215BWLumkes John H · Lafayette, INBuilt 2007 · S/N 54N215KYSparrow Aviation LLC · Marietta, GABuilt 2004 · S/N 20-1045N215LFLf Aviation Inc · Dover, DEBuilt 2004 · S/N 20-1032N2162Brammer Randall D · Belleville, ILBuilt 1973 · S/N P546N216ACLetourneau University · Longview, TXBuilt 2000 · S/N 1381-2000N216DVBusch-Joss Elizabeth M · Blue Point, NYBuilt 1977 · S/N 15280927N216LFEralet Inc · Middletown, DEBuilt 2004 · S/N 20-1034N2178BSouthern Utah University · Cedar City, UTBuilt 1949 · S/N 6605N21879Schiestle Jason T · Greenville, PABuilt 1938 · S/N 2657N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307N218JMAhlgrim Mark W · North East, PABuilt 1990 · S/N 218
Back to AD 80-25-02 R2