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.

N8720PBarry Edward P III · Redlands, CABuilt 1965 · S/N 24-4169N8721PLavergne Rusty P · Denham Springs, LABuilt 1965 · S/N 24-4170N8722PMurphy Josiah I · Jarrettsville, MDS/N 24-4171N8723PSima Ronald Scott · Glendale, AZBuilt 1965 · S/N 24-4172N8725PAyoub Michael Kamal · Saint Charles, MOS/N 24-4174N8729PBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 24-4179N872JWWheeler Jeffrey A · Elyria, OHFirst renewal noticeBuilt 1972 · S/N 32-90N872MN872m LLC · Batavia, OHBuilt 1998 · S/N 27-0248N872RJ&J Surveying & Leasing LLC · Jacksonville, FLBuilt 1989 · S/N 4622028N8732PComanche Aviation Inc · North Bend, OHBuilt 1965 · S/N 24-4182N8733PSpaulding Rachael K · Saint Johns, FLBuilt 1965 · S/N 24-4183N8735EKleiss James · Pesotum, ILBuilt 1976 · S/N 32R7680169N8735PG B W Llp · Slidell, LABuilt 1965 · S/N 24-4185N8741PCrimson Dawn Aviation LLC · Vinton, LABuilt 1965 · S/N 24-4192N8742PLbb High Flyers LLC · Lubbock, TXBuilt 1965 · S/N 24-4194N8743EKopitzke Christopher · Lexington, KYBuilt 1976 · S/N 32R-7680171N8743PAckerman Garry A · Plano, TXBuilt 1965 · S/N 24-4195N8744PJorheim Chris N · Altoona, PABuilt 1965 · S/N 24-4197N8746PRatvasky Harry J · New Wilmington, PABuilt 1965 · S/N 24-4199N8747PEdens Kenneth L · Hot Springs, ARS/N 24-4200N874LLLandry Raymond M · Georgetown, TXBuilt 2005 · S/N T18208457N8752EH & T Air LLC · Huron, SDBuilt 1976 · S/N 32R-7680173N8754PHromek-Sawyer Diane · Lake Tomahawk, WIBuilt 1965 · S/N 24-4204N8756PK T Graham Inc · Ephrata, PABuilt 1965 · S/N 24-4206N8757PHix William W · Walsenburg, COBuilt 1965 · S/N 24-4207N8758PMurphy Robert J · Deland, FLBuilt 1965 · S/N 24-4208N8759EN8759e LLC · Wilmington, DES/N 32R-7680174N8759PHeir Grant · Woodland, CAS/N 24-4209N8760EArchie Airways LLC · Durant, OKBuilt 1976 · S/N 32R-7680175N8761HLejeune Aerial Applications LLC · Basile, LAFirst renewal noticeBuilt 1976 · S/N 1516N8766PStephens Lloyd G · Saratoga, CABuilt 1965 · S/N 24-4216N8767PGen-One Aviation LLC · Carlsbad, NMBuilt 1965 · S/N 24-4217N8768KRegistered aircraftS/N 32-7340149N8768PGliege Allan C · Middleton, IDBuilt 1965 · S/N 24-4218N8770PGores Thomas J · Franklin, WIS/N 24-4220N8773PMcfly Cornhusker LLC · Sarasota, FLBuilt 1965 · S/N 24-4224N8778PTrammell Shaun · Broken Arrow, OKBuilt 1965 · S/N 24-4229N8779CForever Fly LLC · Margate, FLBuilt 1976 · S/N 32R-7680138N877CVBrown Joseph Glenn · Desert Hills, AZBuilt 2004 · S/N T18208307N877DSEvans Ashley E · Elizabeth, COBuilt 1967 · S/N 32-40185N877DWAviation Concepts LLC · Coeur D Alene, IDBuilt 2001 · S/N T18208073N8780PChampion Milton · Reno, NVBuilt 1965 · S/N 24-4232N8781PJenkins Aviation Ventures LLC · Woodstock, GABuilt 1965 · S/N 24-4233N8785FBeving Charles J · Garden City, SDBuilt 1976 · S/N 32R-7780116N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N878BTBlue Paradise Aviation LLC · Clive, IABuilt 2005 · S/N 3257402N878MJJackson Air LLC · Paragould, ARBuilt 1976 · S/N 32-7640078N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8792EMann Joshua A · Montgomery, TXBuilt 1976 · S/N 32R-7680178
Back to AD 84-19-03 R1