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.

N6664YSmooth Air Inc · Ocala, FLBuilt 1968 · S/N 27-3980N666KABeulah Ranch LLC · Cheyenne, WYBuilt 1965 · S/N 1500-177N666KHMks Aviation Of Mt Airy LLC · Mount Airy, NCBuilt 1972 · S/N 24-5026N666KWRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1972 · S/N 27-7304928N667CHBorders Darin · Center, TXBuilt 1978 · S/N 32R-7887191N667RHN667rh LLC · Oakdale, NYBuilt 2002 · S/N 3257290N6682YMcdermott James R · Somerton, AZBuilt 1968 · S/N 27-4003N6698VHeberlein Ronald E · Wilsonville, ORBuilt 1966 · S/N 30004N669CWPrecision Air Inc · Nelson Lagoon, AKBuilt 1969 · S/N 31-514N669JCloud Splitter Inc · Columbia, CABuilt 1963 · S/N 500B-1304-119N669PBluhm Daniel A · Gold Hill, ORBuilt 1966 · S/N 24-4507N66AEAndreassi LLC · Bluffton, SCBuilt 1974 · S/N 31-7405187N66ATDeer Elm Aviation LLC · Owens Cross Roads, ALBuilt 1975 · S/N 31-7552042N66CGPosada Raul Ignacion · El Paso, TXS/N 61P-0277-061N66FRBledsoe James C · Hugo, COBuilt 2002 · S/N T18208107N66JWNowell Borders Equipment G P Inc · Edinburg, TXBuilt 1972 · S/N 27-7304967N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014N66TSTall Timber Flying Service LLC · Kalispell, MTBuilt 2001 · S/N T20608334N66WMTriple R & B Aviation LLC · Miami Beach, FLBuilt 1966 · S/N 32-40002N66YCWatts Loren · Hermiston, ORBuilt 2005 · S/N 27-0344N6707FSeals Jeremy C · Goshen, KYBuilt 1976 · S/N 32R-7780035N6708VAircraft Restoration Service Enhancements LLC · Mesa, AZBuilt 1970 · S/N 31011N670MPStar Ground Services Inc · Tinian, MPBuilt 1971 · S/N 32-7140021N6711YAero Services Lc · Woods Cross, UTBuilt 1968 · S/N 27-4039N6716YGot Wings LLC · Woodbury, NYBuilt 1968 · S/N 27-4046N6719LAwmr LLC · Conroe, TXBuilt 1969 · S/N 31-615N6730YUrubek Raymond L · Refugio, TXS/N 27-4062N6739YTropical Interisland Express Corp · Doral, FLBuilt 1968 · S/N 27-4073N674TCUS Department Of Homeland Security · Washington, DCBuilt 2003 · S/N T20608380N6751YLarson Kris K · Fullerton, CAFirst renewal noticeBuilt 1968 · S/N 27-4079N6754YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1968 · S/N 27-4083N675KAAllis Kevin J · Columbia, MDS/N 14152N6762LSummit Aviation LLC · Sun Valley, IDBuilt 1970 · S/N 31-664N6768YPiper Aircraft Inc · Vero Beach, FLBuilt 1968 · S/N 27-4100N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122N677RARa Aviation LLC · Omaha, NEBuilt 1968 · S/N 24-4764N6786YMuhlenkort Mary Anna · Beresford, SDBuilt 1968 · S/N 27-4122N678RKJ2k Plane LLC · Liberty Twp, OHBuilt 2004 · S/N T18208273N678TBHunter Dennis F · Rohnert Park, CAS/N 1925N678THSky High Aviation LLC · Shelby Township, MIBuilt 1978 · S/N 32R-7887283N67MLBgdr LLC · Wilmington, DEBuilt 1975 · S/N 340-0519N67SPBird Aviation · Salt Lake City, UTBuilt 1980 · S/N 32R-8029066N67TFHorton Richard D · Woodland Park, COBuilt 1999 · S/N 27-0275N67TGMccall Andrew Keith · Abilene, TXBuilt 1989 · S/N 4622032N67WYTramel Air LLC · Midland, TXBuilt 1999 · S/N T20608122N6810YAtem LLC · Helena, ALBuilt 1969 · S/N 27-4148N6812JGottschalk William R · Fort Atkinson, WIBuilt 1976 · S/N 32R-7680352N6817YInternational Air Services Inc Trustee · Carson City, NVS/N 27-4156N681ATCaudullo Alfred A · Bolton, CTBuilt 1977 · S/N 32-7740038
Back to AD 84-19-03 R1