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.

N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026N7419SKcantarano LLC · Mukilteo, WABuilt 1969 · S/N 61-0004N7425SSweeney Sean M · Reunion, FLBuilt 1969 · S/N 61-0010N7426LWright Air Service Inc · Fairbanks, AKBuilt 1972 · S/N 31-812N742HMBennett Aviation LLC · New York, NYBuilt 2001 · S/N T20608304N7432LStandard Air LLC · West Linn, ORBuilt 1972 · S/N 31-820N7434LIsland Wings Inc · Fort Lauderdale, FLBuilt 1972 · S/N 31-822N7438SFrana Joel A · Fort Myers, FLBuilt 1969 · S/N 60-0025N743SLLewis And Hart Development LLC · Nashville, TNBuilt 1984 · S/N 31P-8414037N7441SKp Stunt Productions Inc · Burlington, NDBuilt 1969 · S/N 61-0024N744JCAck-Pg-LLC · Charlestown, MABuilt 1979 · S/N 31-7912119N744RVAustin Aviation LLC · Maumelle, ARBuilt 2003 · S/N 4636342N745AALarson Stephen Blair · Raleigh, NCBuilt 1968 · S/N 32-40449N746AJNesta Joseph A · Kelleys Island, OHBuilt 1975 · S/N 32-7540082N746RRSolis Inc LLC · Alton, NHBuilt 1974 · S/N 75-32-147N747ATHaueisen Jessica · Franklin, GABuilt 1978 · S/N 27-7854080N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070N747HSale Reported · Santa Rosa, CASale reportedBuilt 1965 · S/N 1492-72N747MEEvans Mark W · Camillus, NYBuilt 1993 · S/N 117N7482WSkys Edge Aviation LLC · Midland, TXS/N 27-3524N748NPBelle Island Management LLC · Fort Lauderdale, FLBuilt 1969 · S/N 31474N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074N7496SSmith Linda L · Port Charlotte, FLBuilt 1970 · S/N 60-0047-108N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016N74LRRemy Lange · East Greenville, PAS/N 27-7405363N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272N74WDNevada Viking Partners LLC · Stateline, NVBuilt 1973 · S/N 73-31065N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246N75034Rpm Aviation LLC · Hillsborough, NCBuilt 1976 · S/N 32R-7680248N7503SStout Joel D DBA · New Cumberland, PAS/N 61-0066-122N7507SBlue Sky Aviation Inc · Texico, NMBuilt 1970 · S/N 61-0068-126N7509SBlueskys Inc · Wilmington, DEBuilt 1970 · S/N 60-0056-128N750AWMagumbo Aviation LLC · Macomb, MIBuilt 1974 · S/N 32-7540018N750GVTrak Inc · Gainesville, GABuilt 2000 · S/N 3257171N75143Raisch Horst F · Aptos, CABuilt 1976 · S/N 32R-7680263N75195Swaz Aviation LLC · Mesa, AZS/N 32R-7680277N75196Woodberry Robert A · Mineral, VABuilt 1976 · S/N 32R-7680278N75247G W R LLC · Wilmington, DEBuilt 1976 · S/N 32R-7680282N75267Avian Aerospace LLC · Mansfield, OHBuilt 1976 · S/N 32R-7680284N75279Workman Randy C · Bells, TXBuilt 1976 · S/N 32R-7680285N7528SDoran Jeff T · Westerville, OHS/N 60-0190-086N75298Registration Pending · Memphis, MORegistration pendingS/N 32R-7680287N75299Rmb Helicopters LLC · Factoryville, PABuilt 1976 · S/N 32R-7680289N752LSouthwest Aviation Enterprises · Haslet, TXBuilt 2006 · S/N T20608595N7533CWilson Rodney D · Whiteville, TNBuilt 1975 · S/N 32-7640045N7533SD & T Wilson Co Inc · Hillsboro, INBuilt 1974 · S/N 60-0165-073N75387Latitude 63 LLC · Anchorage, AKBuilt 1976 · S/N 32R-7680298
Back to AD 84-19-03 R1