AD 47-51-13

Registered aircraft · 131

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

N86815Schnabel Albert Jr · Spencerport, NYBuilt 1946 · S/N 1176N86826Gould Russell P · May, TXBuilt 1946 · S/N 1187N86831Kown William B · Hamilton, ALFirst renewal noticeBuilt 1946 · S/N 1192N86841Aero Legacy Foundation · Basehor, KSS/N 1202N86845Kronberger Warren J · Minooka, ILBuilt 1946 · S/N 1206N86851Sale Reported · Graham, WASale reportedBuilt 1946 · S/N 1213N86857Kimbrel Michael G · Oakville, WABuilt 1946 · S/N 1219N86866Eberhardy John F · Radisson, WIBuilt 1946 · S/N 1228N86867Bellanca Nc86867 LLC · Beecher, ILS/N 1229N86868Chisum Robert · Lorenzo, TXS/N 1230N86873Mcguire William P · Gobles, MIBuilt 1946 · S/N 1235N86875Hanson John G · Marion, MTS/N 1237N86880Berger Greg D · Prescott, AZBuilt 1946 · S/N 1242N86881Cullman Daniel H · Kent, WABuilt 1946 · S/N 1243N86889Air Cargo & Taxi LLC · Prescott, AZBuilt 1946 · S/N 1251N86897Chappel Steve · Stanwood, WABuilt 1946 · S/N 1259N86903Tegeler George J · Elkader, IABuilt 1946 · S/N 1265N86909Dudnelly James · Oklahoma City, OKBuilt 1946 · S/N 1271N86916Apogee Investments LLC · Grandview, TXBuilt 1946 · S/N 1278N86919Latham Ray H · Raymond, WABuilt 1946 · S/N 1281N86920Cross Thomas W · Redding, CABuilt 1946 · S/N 1282N86925Riley Samuel L · Harrison, ARS/N 1287N86930Milwrick Donald D · Lincoln, MIBuilt 1946 · S/N 1292N86934Simply Living LLC · Fort Myers, FLBuilt 1946 · S/N 1296N86935Walenceus William A · Oelwein, IABuilt 1946 · S/N 1297N86937Ohlinger Mark A · Copley, OHBuilt 1946 · S/N 1299N86944Franklin Gary Wayne · Lubbock, TXBuilt 1946 · S/N 1306N86947Woodbridge Arlen · Rupert, IDBuilt 1946 · S/N 1309N86949Redtail Flyers Inc · Kalispell, MTBuilt 1946 · S/N 1210N86APatrick Ross A · Orange Park, FLBuilt 1946 · S/N 1211N88ZKinyon Kyle W · Newman Lake, WABuilt 1949 · S/N 1629
Back to AD 47-51-13