OpenAirDocs.org
AD 84-19-03 R1

Registered aircraft · 5,075

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:84-19-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-19-03-R1')
  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.

N800MSMcghee John M · Breckenridge, COBuilt 1991 · S/N 270107N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011N8016PSteelera Aviation LLC · Wolfforth, TXBuilt 1962 · S/N 24-3260N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460N801DPSunset Aviation Services LLC · Coeur D Alene, IDBuilt 1960 · S/N 500B-999-30N801KPlumlee James H · Bluffton, SCBuilt 1961 · S/N 500B-1094-57N801PCGrand Michael · Palacios, TXBuilt 1965 · S/N 24-4256N8021ULundell Brad · Kiron, IABuilt 1981 · S/N 28-8211020N8023PShisier William · Tempe, AZBuilt 1962 · S/N 24-3267N8024YValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 32R-8229018N8025JTorres Rafael · San Juan, PRBuilt 1978 · S/N 60-0503-163N8028PTrest Robert J · Pelzer, SCBuilt 1962 · S/N 24-3274N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103N802SDFly Blew LLC · Fayetteville, ARBuilt 2004 · S/N T18208239N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065N8041HKing Ag Leasing Inc · Sudan, TXBuilt 1981 · S/N 32R-8229022N8041MLewis Edward H · Moorestown, NJBuilt 1981 · S/N 32R-8229023N8042GTemple In The Sky LLC · Marietta, GABuilt 1981 · S/N 32R-8229024N8043PGray Motors Inc · Port Angeles, WABuilt 1962 · S/N 24-3289N8047SRisso Christopher W · Huntington Beach, CABuilt 1981 · S/N 32R-8229025N8052PCornerstone Dec Ltd · Chico, CABuilt 1962 · S/N 24-3298N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109N8062TDitullio Peter C · Fallbrook, CABuilt 1981 · S/N 32R-8229027N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023N8065JHerlihy John Joseph · Arroyo Grande, CABuilt 1978 · S/N 61P-0548-234N8067JCc Air LLC · Orchard, NES/N 60-0550-178N8067PShreve Jerry L · Warrensburg, MOBuilt 1962 · S/N 24-3314N8069SGates Joel L · Salida, COBuilt 1981 · S/N 32R-8229028N80702Over The Numbers LLC · Churchville, PABuilt 1981 · S/N 32R-8229030N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183N807FPM&A Industrial Construction LLC · Atkinson, NEBuilt 1977 · S/N 32R-7780518N8087EJd Aviation Inc · Muskegon, MIBuilt 1979 · S/N 32R-8029019N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128N808DLSons Aviation Inc · Moody, ALBuilt 1967 · S/N 32-40309N808DTGh Aircraft Leasing LLC · Coconut Creek, FLBuilt 2001 · S/N T20608278N8090TN8090t LLC · Austin, TXBuilt 1979 · S/N 32R-8029020N8095PGramas Illya W · Shelby, MIBuilt 1962 · S/N 24-3344N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006N8097CImmell Michael · Buffalo, OKBuilt 1975 · S/N 32-7640052N809BWGilly Christian · Newtown, PABuilt 2005 · S/N 27-0334N809DWReed Land & Properties LLC · Kalispell, MTBuilt 2002 · S/N T18208109N80DECampbell Bradford D · Groton, CTBuilt 1973 · S/N 74-31083N80FFP A M Aviation LLC · Portsmouth, NHBuilt 1972 · S/N 27-7304958N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003N80LKEti Aviation LLC · Boynton Beach, FLBuilt 1977 · S/N 31-7712103N80NDMerrifield Robert Craig · Fitzgerald, GAS/N 24-4164N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050N810MJCampbell Fred Cox · Monroe, NCBuilt 1974 · S/N 32-7440082N8118XSchultz Robert J · Rapid City, SDBuilt 1979 · S/N 32R-8029011N8118ZWest Metro Aviation LLC · Buffalo, MNBuilt 1979 · S/N 32R-8029013
Back to AD 84-19-03 R1