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.

N30CBMoyer Scott L · Southlake, TXS/N NAV-4-2202BN30DWilderness Aviation LLC · Kalispell, MTS/N NAV-4-2183BN312NMHks Aviation LLC · Tampa, FLBuilt 1947 · S/N NAV-4-563N3178GBrandt Goetz K · San Jose, CABuilt 1947 · S/N NAV-4-861N3374GBangle Delbert F · El Cajon, CABuilt 1948 · S/N NAV-4-1280N344JTedesco Fred A · Newport Beach, CABuilt 1947 · S/N NAV4-196N36DSummer Winds II LLC · Lafayette, INBuilt 1950 · S/N NAV-4-2217BN36WTrans Nevada Express Inc · El Centro, CABuilt 1950 · S/N NAV-4-2263BN3864Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1951 · S/N NAV-4-2285BN3GGCampbell William J DBA · Santa Rosa, CABuilt 1949 · S/N NAV-4-1824N4000GTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1920N4001KZahn Mark V · Sarasota, FLBuilt 1947 · S/N NAV-4-1001N4008KOlson Eric C · Seattle, WABuilt 1947 · S/N NAV-4-1008N4012KKane Robert F · Wilton, CAFirst renewal noticeBuilt 1947 · S/N NAV-4-1012N4015KCarroll David A · Gibsonville, NCS/N NAV-4-1002N4016KHatch David G · Clovis, CABuilt 1947 · S/N NAV-4-1016N4020KMeinen Albert D · Troy, ILBuilt 1947 · S/N NAV-4-1020N4021KNorthwest Navion Inc · Arlington, WAS/N NAV41021N4026KWarbird Holdings LLC · Middletown, DEBuilt 1947 · S/N NAV-4-1026N4029KCampbelll William Jr T · Sand Springs, OKBuilt 1947 · S/N NAV-4-1029N4030KBurnett David Mark · Scott City, KSBuilt 1947 · S/N NAV-4-1030N4032KWeise David D · Lakewood, COS/N NAV-4-1032N4037KByrne Sofia V · Merrimack, NHBuilt 1947 · S/N NAV-4-1037N4043KJackson Ian C · Rochester, NHBuilt 1949 · S/N NAV-4-1043N4045KCincy Warbirds LLC · West Chester, OHBuilt 1947 · S/N NAV-4-1045N4047KJed Homes Inc · Lisbon, CTS/N NAV-4-1047N4080K80 Kilo LLC · Hammond, LAS/N NAV-4-1080N4101KBravery Aviation LLC · Viburnum, MOS/N NAV-4-1101N4102KTomlin Rollin D · Wilmington, OHBuilt 1947 · S/N NAV-4-1102N4106KBriggs Dan E · Hayden, IDS/N NAV-4-1106N4110KDdrl Holdings LLC · Missoula, MTBuilt 1947 · S/N NAV-4-1110N4111KMillar Charles R · Maricopa, AZS/N NAV-4-1111N4124KOtt Dean R · Carrollton, OHBuilt 1947 · S/N NAV-4-1124N4126KNichols Jan L · Bonham, TXS/N NAV-4-1126N4130KColvin Buster · Big Cabin, OKS/N NAV-4-1130N4131KDarnall Lane · Harrisburg, NEBuilt 1947 · S/N NAV-4-1131N4132KJohnston William D · Visalia, CAS/N NAV41132N4134KOv-10 Bronco Association Inc · Fort Worth, TXBuilt 1947 · S/N NAV-4-1134N4135KBurlace Thomas J III · Aurora, COBuilt 1948 · S/N NAV-4-1135N4139KStone Jason · Wellington, KSS/N NAV-4-1139N4142KHopkins Frank · Wilmington, DEBuilt 1948 · S/N NAV-4-1142N4143KDerickson Russell J · Lamberton, MNBuilt 1948 · S/N NAV-4-1143N4145KGerondale Gregory · Tulsa, OKS/N NAV-4-1145N4146KHolmes Peter N · Spokane, WABuilt 1948 · S/N NAV-4-1146N4150KTomlin Rollin D · Wilmington, OHBuilt 1949 · S/N NAV-4-1150N4156KLohse Charles R · Onalaska, WAS/N NAV-4-1156N4158KHester Jesse S · Mclean, VAS/N NAV-4-1158N4169KAndersen Nicholas · Logan, UTS/N NAV-4-1169N4172KRegistration Pending · Lebanon, CTRegistration pendingBuilt 1948 · S/N NAV-4-1172N4179AWeaver Gary M · Morgantown, INBuilt 1948 · S/N NAV-4-1628
Back to AD 53-08-01