OpenAirDocs.org
AD 53-03-01

Registered aircraft · 113

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-03-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-03-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.

N10894Holcomb Daniel F · Galena, ILS/N NAV42333BN27AWBold William H Jr · Annapolis, MDBuilt 1950 · S/N 4-2172BN2893DAshurst Brent H · Westmorland, CABuilt 1951 · S/N 2242BN29PNavion West Inc · Northridge, CABuilt 1951 · S/N NAV-4-2320BN2WDBrantley Scott R · Great Bend, KSBuilt 1950 · S/N NAV-4-2153-BN300CBAerial Ads Of Pittsburgh Inc · Allison Park, PABuilt 1950 · S/N NAV-4-2237BN30CBMoyer Scott L · Southlake, TXS/N NAV-4-2202BN30DWilderness Aviation LLC · Kalispell, MTS/N NAV-4-2183BN36DSummer 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-2285BN4197KRichardson Walter J Jr · Aliceville, ALBuilt 1947 · S/N NAV-4-1197N422HJTomlinson Paula L · Redmond, WAS/N NAV-4-2289BN435CKrokosz Michael · Cottonwood, AZBuilt 1950 · S/N NAV-4-2167BN444RBHeath David · Winona, MSBuilt 1950 · S/N NAV-4-2170BN456HWestwind Inc · Marina, CABuilt 1951 · S/N NAV-4-2228-BN45VPhillips Allen K · Leadville, COS/N NAV-4-2236BN488DSTaylor Ralph S · Inver Grove Hts, MNS/N NAV-4-2126BN4951KSupp Charles M · Wells, NVBuilt 1950 · S/N 2148BN4SKSierra Kilo Corporation · New York, NYBuilt 1947 · S/N NAV-4-554BN5130KSupp Robert W · Wells, NVBuilt 1950 · S/N NAV-4-2030BN5131KBittner Edwin J · Greenbank, WABuilt 1950 · S/N 2031BN5132KAmbassador Cartage Inc · Rocky Mount, MOBuilt 1950 · S/N NAV-4-2032BN5149KNorthwest Navion Inc · Arlington, WABuilt 1950 · S/N NAV-4-2049BN5151KKelleyworks LLC · Nampa, IDBuilt 1950 · S/N NAV-4-2051BN5156KHanover Holding Co · Elkhart, INBuilt 1950 · S/N NAV-4-2056BN5160KStearns Brian Olson · Valencia, CAS/N 2060BN5162KHensley Bradley S · Lake Charles, LAS/N NAV-4-2062BN5173KNavion West Inc · Northridge, CABuilt 1950 · S/N NAV-4-2073BN5174KFeather Gerald B · Grand Junction, COS/N NAV-4-2074-BN5176KHalpin William J · Eden Prairie, MNBuilt 1950 · S/N NAV-4-2076BN5188KGilman John · Yakima, WAS/N NAV-4-2197BN5191KMailloux Jacques M · Denver, COBuilt 1950 · S/N NAV-4-2091BN5192KTango Kilo Enterprises LLC · Sarasota, FLBuilt 1950 · S/N NAV-4-2092BN5195KEddleman John C · Los Alamos, NMBuilt 1950 · S/N NAV-4-2095BN5198KGalbreath Micheal F · Oberlin, OHS/N NAV-4-2098BN5202KSkinner Walter M · Naples, FLBuilt 1952 · S/N NAV-4-2102BN5203KZeller Brenda D · Meridian, MSBuilt 1950 · S/N NAV-4-2103BN5217KHess Garrett J · Fullerton, CABuilt 1950 · S/N NAV-4-2117-BN5218KBaumgartner Dennis · Everett, WAS/N 2118BN521TAnderson Oluf J · Rangely, COS/N NAV-4-2244BN5220KStewart Jack · Jacksonville, ILS/N NAV-4-2120BN5221KYoung Gregory · Spring, TXBuilt 1950 · S/N NAV-4-2121BN5228KD/S Aviation LLC · Las Vegas, NVS/N NAV-4-2128BN5229KHeintz Ricky Lee · Dewey Humboldt, AZS/N NAV42129BN5235KMeinen Albert D · Troy, ILBuilt 1950 · S/N 2135BN5237KFoss James K · Anchorage, AKBuilt 1950 · S/N NAV-4-2137BN5242KPence Dale E · Richmond, MOBuilt 1950 · S/N NAV-4-2142BN5246KNavion Element LLC · Prior Lake, MNBuilt 1950 · S/N NAV-4-2146BN5252KTupper Joel · Guthrie, OKBuilt 1950 · S/N NAV-4-2152B
Back to AD 53-03-01