OpenAirDocs.org
AD 54-02-02

Registered aircraft · 2,595

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:54-02-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:54-02-02')
  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.

N1020UNorth Central Aircraft Sales · Tioga, NDS/N 18783N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128N108DFMurtagh Johnny T · Lexington, MSBuilt 1946 · S/N 10860N108TSHesser Dale W · Cardington, OHBuilt 1952 · S/N 20328N108TTTurnbull Archie · Ypsilanti, MIBuilt 1946 · S/N 108-534N108WWBingham Merle G · Hickson, NDBuilt 1946 · S/N 108-384N1099PHansen K Brent · Captain Cook, HIS/N 20-510N111LKnuth Dale G · Hartford, SDBuilt 1952 · S/N 20642N112QBFloyd Austin · Searcy, ARBuilt 1955 · S/N 26952N112RPTaylor Chad A · Enid, OKBuilt 1950 · S/N 19422N11575Pyle Howard H · Cornelius, ORBuilt 1950 · S/N 19540N1171CUnser Joshua D · Anchorage, AKBuilt 1953 · S/N 20-963N117GSSimdorn William N · Scappoose, ORBuilt 1956 · S/N 27157N118FRemington William J · Decorah, IABuilt 1952 · S/N 25329N1208DMusgrove James F · Burien, WABuilt 1955 · S/N 19762N1209RRowley Timothy · Roopville, GABuilt 1954 · S/N 26152N1212DN1212d LLC · Boise, IDS/N 19766N1215DMytth Spray Solutions Inc · Easley, SCBuilt 1950 · S/N 19769N1221DJamison Tim · Oklahoma City, OKBuilt 1951 · S/N 19982N1224DByrer Jesse A · Monrovia, INBuilt 1951 · S/N 20114N1224VCarter John T · Huntington Beach, CABuilt 1952 · S/N 20358N1227DWhite Michael D · Willow Springs, MOBuilt 1950 · S/N 19781N1228DBell Stephen R · Carleton, MIBuilt 1950 · S/N 19782N1231DNeel Aviation LLC · Lakeland, FLBuilt 1950 · S/N 19785N1235DStates Douglas S · Geneseo, ILBuilt 1951 · S/N 20118N1240DBaeder Mark A · Mesa, AZBuilt 1950 · S/N 19794N1242DPrice John C · Bennington, KSBuilt 1949 · S/N 18734N1244DBackcountry Aviation LLC · Ankeny, IAS/N 19798N1245DChism Jerry · Austin, ARBuilt 1950 · S/N 19799N1247CSmith Paul J · Fremont, OHBuilt 1953 · S/N 20-968N1247DWroe Daniel C · Denton, MDS/N 20119N124QKepes Bruce R · So Charleston, OHBuilt 1948 · S/N 18509N1250DSmith Christopher R · Manvel, TXBuilt 1951 · S/N 20122N1256DYoung Robert J · Conroe, TXBuilt 1950 · S/N 19810N1257DKendrick Ross M · Sycamore, GABuilt 1951 · S/N 19811N1258DInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N 19812N1259DBrown Nicholas J · West Valley City, UTBuilt 1950 · S/N 19813N125RCChambers William M · Elkmont, ALS/N 20-615N1261DEpstein Neal R · Medway, MABuilt 1950 · S/N 19815N1262DBohanan Robert C · Denali Park, AKBuilt 1950 · S/N 19816N1263DSellers Kevin D · Baytown, TXBuilt 1950 · S/N 19822N1264DReason Cole · Yakima, WABuilt 1951 · S/N 19840N1265DWiseth Devin · Grand Rapids, MNBuilt 1951 · S/N 19841N1266DA T Enterprises Ltd · Three Forks, MTBuilt 1950 · S/N 19842N1273DJones William J · Villa Grove, ILBuilt 1951 · S/N 19849N1276DLehr Denis J · Sacramento, CABuilt 1951 · S/N 20124N1277DEllison Phillip · Castle Hayne, NCBuilt 1951 · S/N 19853N1281DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N 19857N1286DPolicani Desmond M · Tacoma, WABuilt 1951 · S/N 19862N1288DConner Brent F · Medford, ORBuilt 1951 · S/N 19861
Back to AD 54-02-02