OpenAirDocs.org
AD 2004-21-08 R1

Registered aircraft · 511

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:2004-21-08-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:2004-21-08-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.

N2137CSchmiedt Daniel M · Westminster, SCBuilt 1954 · S/N 16122N2137DVasenden David A Trustee · Verdi, NVBuilt 1952 · S/N 7905N2139CWilson Todd B · Newnan, GABuilt 1953 · S/N 16124N2140CMilton William H · Amsterdam, NYS/N 16125N2142CSteinsvik Magne · Seattle, WABuilt 1953 · S/N 16127N2147CBas Part Sales LLC · Greeley, COBuilt 1954 · S/N 16132N2149CYoung Marlon V · Santa Rosa, CABuilt 1954 · S/N 16134N2151CAtkinson Patrick C · Fort Worth, TXBuilt 1954 · S/N 16136N2152CTeenie 1 LLC · Boynton Beach, FLBuilt 1954 · S/N 16137N2154CBoynton Scott E · Campbell Hall, NYS/N 16139N2156CZoom Leasing LLC · Barto, PABuilt 1954 · S/N 16141N2158CSlocum James E · Poplar Grove, ILBuilt 1954 · S/N 16143N2160CStephenson Stephanie V · Colby, KSBuilt 1954 · S/N 16145N2161CHendrix Todd M · Bakersfield, CABuilt 1954 · S/N 16146N2165CHaltom Alan W · Centennial, COBuilt 1954 · S/N 16150N2166CMaples Jeffery · Belle, MOBuilt 1954 · S/N 16151N2168CHowerton Pammela S · Bartlesville, OKBuilt 1954 · S/N 16153N2172CMcintire Larry C · Marietta, GABuilt 1954 · S/N 16157N2174CCanandaigua Air Center LLC · Canandaigua, NYBuilt 1954 · S/N 16159N2175CHoffpauir Stanley C · Waller, TXBuilt 1954 · S/N 16160N2180CBerg Alvin L · Overgaard, AZBuilt 1955 · S/N 16165N2185CRichards William R · Columbus, INBuilt 1955 · S/N 16170N2186CBucher Burton W · North Chicago, ILBuilt 1955 · S/N 16171N2187CEnvisage LLC · Virginia Beach, VAS/N 16172N2190CSchmiedt Daniel M · Westminster, SCBuilt 1955 · S/N 16175N2192CHamann David L · Los Lunas, NMBuilt 1955 · S/N 16177N2193CClerx Bernard C · Newport Beach, CABuilt 1955 · S/N 16178N2194CFavero Sebastian A · Poway, CABuilt 1955 · S/N 16179N2195CGunter Bradley M · Canon City, COBuilt 1954 · S/N 16180N2196CPelton Jack J · Wichita, KSBuilt 1955 · S/N 16181N2197CVintage Aircraft Sales LLC · Radnor, OHBuilt 1954 · S/N 16182N251ZWatkinds Steven G · Hermiston, ORBuilt 1952 · S/N 7842N252BBJagmin Michael · Chicago, ILBuilt 1950 · S/N 7571N2648Gaddis Donald O · Fredericksburg, OHBuilt 1952 · S/N 7797N272CGStrickland Luther J Jr · San Luis Obispo, CABuilt 1949 · S/N 7301N295APTupelo Aeronautics Inc · Tupelo, MSS/N 7836N3001BLarsen James · Santa Rosa, CABuilt 1952 · S/N 7884N3004BDirksen Daniel L · Montevideo, MNBuilt 1952 · S/N 7887N3005BStreamline Aviation LLC · Battlefield, MOS/N 7888N3006BMabry Thomas Coleman II · Atlanta, GABuilt 1952 · S/N 7889N3010BEuroaviation Inc Trustee · KematenBuilt 1952 · S/N 7893N3011BCarney Jeffrey · Langhorne, PABuilt 1952 · S/N 7894N3015BDaniel Thompson G Jr · Greensboro, NCBuilt 1952 · S/N 7898N3021BChase 13 LLC · Wilmington, DES/N 7904N3023BWelch Thomas R · Modesto, CABuilt 1952 · S/N 7906N3026BMacario T Michael · Townsend, DEBuilt 1952 · S/N 7909N3027BLacey William F · Parker, COBuilt 1952 · S/N 7910N3029BWilson Christopher W · Edgewood, NMBuilt 1952 · S/N 7912N3031BPontieri Kari · Parma, OHBuilt 1952 · S/N 7914N3032BHendrix Todd M · Bakersfield, CABuilt 1952 · S/N 7915
Back to AD 2004-21-08 R1