AD 53-08-01

Registered aircraft · 747

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

N4180KCooper Melvin R Jr · Prineville, ORBuilt 1948 · S/N NAV-4-1180N4183KGroth Matthew C · Arlington, WABuilt 1948 · S/N NAV-4-1183N4185KKennedy John E · Martinsville, INBuilt 1948 · S/N NAV-4-1185N4188KMartino Victor H · Port Wentworth, GABuilt 1948 · S/N NAV-4-1188N4190KPflaum Dudley T Trustee · Henderson, NVBuilt 1948 · S/N NAV-4-1190N4191KWells David M · Ada, MIS/N NAV-4-1191N4193KPrice Steven C · Midland, TXBuilt 1948 · S/N NAV-4-1193N4197KRichardson Walter J Jr · Aliceville, ALBuilt 1947 · S/N NAV-4-1197N4201KSuttles B Hugh · Walhalla, SCBuilt 1948 · S/N NAV41201N4202KNavion Aviators LLC · Greenwood, MSBuilt 1948 · S/N NAV-4-1202N4210KBosch Kent D · Montevideo, MNS/N NAV-4-1210N4213KPontiff Elizabeth D · Sterling, VABuilt 1948 · S/N NAV-4-1213N4214KChristopher Michael L · Gerlach, NVBuilt 1948 · S/N NAV-4-1214N4224KDickson Robert T · Charlotte, NCBuilt 1948 · S/N NAV-4-1224N4226KTroeleman Adrian John · Naples, FLBuilt 1948 · S/N NAV-4-1226N4229KLead And Brass Racing LLC · Helena, MTS/N NAV-4-1229N422HJTomlinson Paula L · Redmond, WAS/N NAV-4-2289BN4230KHarper Paul V · Minerva, OHBuilt 1948 · S/N NAV4-1230N4238AHigh Noon Aviation LLC · Loveland, COS/N NAV-4-1736N4241KSmith Glen R · Tracy, MNBuilt 1948 · S/N NAV-4-1241N4242KNaviation LLC · Kalispell, MTBuilt 1948 · S/N NAV-4-1242N4244KKlungle William C · Grand Haven, MIBuilt 1948 · S/N NAV-4-1244N4251KVlahakis Gregory G · San Jose, CABuilt 1948 · S/N NAV-4-1251N4254KRankin Gary L · Meade, KSBuilt 1948 · S/N NAV-4-1254N4255KWheeler Douglas A · Mount Vernon, OHS/N NAV-4-1255N4262KBeaver Richard G · Spring, TXS/N NAV-4-1262N4264AReed William B · Cortlandt Manor, NYBuilt 1947 · S/N NAV-4-606N4264KBejvan David E · Milwaukee, WIBuilt 1948 · S/N NAV-4-1264N4267KStrength Vernon E · Eureka, CAS/N NAV-4-1267N4271KMoeding Michael M · Emporia, KSBuilt 1948 · S/N NAV-4-1271N4276KDunn Emet C III · Coolidge, AZBuilt 1948 · S/N NAV-4-1276N4278KUrubek Raymond L · Refugio, TXBuilt 1948 · S/N NAV-4-1278N4281KSperl Robert D · Keymar, MDBuilt 1948 · S/N NAV-4-1281N4284KHornblower Paul S · Chilmark, MABuilt 1948 · S/N NAV-4-1284N4286KDeemer Jerry C · Granbury, TXBuilt 1948 · S/N NAV-4-1286N4287KGarre William C · Flint, TXBuilt 1948 · S/N NAV-4-1287N4288KKrug III George R · Keller, TXS/N NAV-4-1288N4289KForsberg Edwin E · Elk Grove, CABuilt 1948 · S/N NAV-4-1289N4294CBaldwin Stephen A · Olalla, WABuilt 1948 · S/N NAV-4-1653N4305KSeferian Matthew C · Omaha, NEBuilt 1948 · S/N NAV-4-1305N4309KRezich James N · Winnebago, ILBuilt 1948 · S/N NAV-4-1309N4312KJorsey Allen Jr · Reidsville, NCBuilt 1948 · S/N NAV-4-1312N4315KFridley John K · Palatka, FLBuilt 1948 · S/N NAV41315N4317KEdwards Freeman Allen · Lake Butler, FLBuilt 1948 · S/N NAV-4-1317N4319KWings Den LLC · Wilmington, DEBuilt 1948 · S/N NAV-4-1319N4321KAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1946 · S/N NAV-4-1321N4323KRothfleisch Joseph Ryan · Brawley, CABuilt 1948 · S/N NAV-4-1323N4328KSpringer Kelly · Edmonds, WABuilt 1948 · S/N NAV-4-1328N4331KAviation Systems Engineering Company Inc · Lexington Park, MDBuilt 1948 · S/N NAV41331N4332KAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1948 · S/N NAV-4-1332
Back to AD 53-08-01