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.

N2847JMoses Henry A · Uvalde, TXBuilt 2002 · S/N 3257288N284HBAviatiek LLC · Hudsonville, MIBuilt 1979 · S/N 31-7912099N285JLLink Air Service LLC · Minong, WIS/N T20608373N285MEN285me Holding LLC · Palm City, FLS/N 31-7405410N285PSShavinsky John E · Fairfield, CTBuilt 1981 · S/N 32R-8229007N288WEAviators LLC · Edina, MNBuilt 1983 · S/N 32-8324008N28934Johnson Grant M · Odessa, FLBuilt 1981 · S/N 32R-8129008N289JGNex Gen Paving Inc · Sanford, TXBuilt 1998 · S/N 3257030N28BEHaas Edward F · Batesville, ARBuilt 1979 · S/N 32-7940147N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121N28HSStone Michael S · Chamois, MOBuilt 1967 · S/N 32-40351N28JKTorps LLC · Southlake, TXBuilt 1998 · S/N 4636164N28KEGrant Aviation Inc · Anchorage, AKS/N 31-8152049N28PVJordak Thomas · Simpsonville, SCBuilt 1978 · S/N 32R-7985008N2904PRandall Airlines LLC · Wendell, NCBuilt 1965 · S/N 24-4191N2908YAnco Air Inc · Weston, FLS/N 32R-8129100N290DYZumm Thomas Lawrence · Wheaton, ILBuilt 2002 · S/N 2108N290HLynco Air LLC · Venice, FLS/N 27-0290N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111N292HCarlisle Services LLC · Pine Mountain, GABuilt 1999 · S/N 3257094N292SMartin James David · Graford, TXBuilt 1976 · S/N 3274N2932QK & W Aviation LLC · Jackson, TNBuilt 1977 · S/N 32-7740055N2943QAurand Bradley · Selinsgrove, PABuilt 1977 · S/N 32R-7780272N2947Moran M Michael · Chico, CAS/N 24-4681N295MRCarrera Air LLC · Tampa, FLBuilt 2005 · S/N 3257405N295SKds Aviation LLC · Normal, ILS/N 4636174N29623Swann Hardy · Nacogdoches, TXBuilt 1979 · S/N 32R-7987123N2968LWills Terry W · Cedar Park, TXBuilt 1979 · S/N 32R-7987125N2969QOsullivan James S · Palo Alto, CABuilt 1977 · S/N 32-7740056N296CHTgl Partners LLC · Plant City, FLBuilt 1978 · S/N 31-7812062N297CLivestock Health Products-Texas Inc · Dalhart, TXBuilt 2004 · S/N 4636359N297JGInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 317952043N297PMCentral City Aviation LLC · Carrington, NDBuilt 1997 · S/N 4636101N29872Mijoba Nadesha · Raleigh, NCBuilt 1972 · S/N 31-7300932N298ATAltura Holdings LLC · New Albany, MSBuilt 1998 · S/N 3257069N29ABStevens Timothy E · Tyrone, GABuilt 1976 · S/N 32R-7780027N29ZQ888wm LLC · Wilmington, DEBuilt 1986 · S/N 37N2BZBosco74 LLC · Wilmington, DEBuilt 1975 · S/N 3227N2DPGreat Circle Flying Club Inc · Sandusky, OHBuilt 1973 · S/N 32-7340112N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342N2MHN2mh LLC · Albuquerque, NMS/N 32R-7887009N2PBRoth Jon A · Rch Palos Vrd, CABuilt 1973 · S/N 60-0140-060N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126N2RTBarnett Keri Trustee · Brownfield, TXBuilt 1969 · S/N 24-4830N2SBMarz Richard F · Statesboro, GABuilt 1973 · S/N 32-7440011N2SXCastello Gregory R · Spencer, WVBuilt 1975 · S/N 32R-7680020N2UBBritten Dennis M · Natchitoches, LABuilt 1976 · S/N 61P-0321-089N2VKWings & Rotors LLC · Wilmington, DES/N 61P-0328-093
Back to AD 84-19-03 R1