AD 48-45-01

Registered aircraft · 219

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:48-45-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:48-45-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.

N4732GAmerican Airpower Heritage Flying Mu · Dallas, TXBuilt 1965 · S/N 10846N47397Discoe Alexander · Kingsburg, CARegistration revokedBuilt 1941 · S/N T411274N47439Welch Raymond · Elgin, ILRegistration revokedBuilt 1943 · S/N 5233AEN47747Walk Michael J · Englewood, FLBuilt 1943 · S/N T43-5488N47803Yanks Air Museum · Baldwin Park, CABuilt 1943 · S/N 8163AEN47922Nelson Flying Service Inc · Sidney, NEBuilt 1943 · S/N 8063AEN47986Daniel Hardy L Jr · Derby, KSS/N T42-3157N48047Daniel Hardy L Jr · Derby, KSS/N 6803AEN48144Farley Sarah A · Rice, TXBuilt 1943 · S/N T43-7042N48154Sale Reported · Redlands, CASale reportedBuilt 1943 · S/N T437053N48328Mojo Aerospace LLC · Wilmington, DEBuilt 1945 · S/N 7263AEN48488Busha James P · Oshkosh, WIBuilt 1943 · S/N T435751N48671Acme Flyers LLC · Austin, TXBuilt 1941 · S/N T41-1191N48705Chi Aerospace Inc · Portsmouth, NHBuilt 1943 · S/N 7493AEN48841Riffle George W · Auburn, WABuilt 1941 · S/N T41-997N49071Hawaii Warbirds Inc · Honolulu, HIBuilt 1943 · S/N T43-5310N49232Casa Acquisitions LLC · Winter Haven, FLS/N T43-5055N49238American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T42-3530N49462Mertesdorf John P · Nicollet, MNBuilt 1943 · S/N T43-4340N49481Fleeman Joseph R · Lawrenceburg, TNFirst renewal noticeBuilt 1942 · S/N FV162N49795Hammond James F · Yellow Springs, OHBuilt 1941 · S/N T411222N49797American Airpower Heritage Flying Museum · Dallas, TXBuilt 1945 · S/N T42-3273N49830Mitchard John J · Sherrills Ford, NCBuilt 1943 · S/N 5203AEN50024Mid Atlantic Air Museum Inc · Reading, PABuilt 1943 · S/N 6143AEN50175Obowa Denis J · Fergus Falls, MNBuilt 1943 · S/N T43-5301N50341Hooey Kevin M · Corning, NYBuilt 1941 · S/N T41-446N50420Cutigni David L · Spencerville, INBuilt 1941 · S/N T41-768N50426American Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N T43-5197N50429Aircraft Registration Inc Trustee · KematenBuilt 1943 · S/N T43-5205N50481American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1945 · S/N 6103AEN50809Dudley Denise M · Santa Margarita, CABuilt 1942 · S/N 7763AEN51090Butler County Warbirds Inc · Middletown, OHBuilt 1943 · S/N T43-5048N51173American Airpower Heritage Flying Museum · Dallas, TXBuilt 1944 · S/N 10564AEN51263American Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N T42-1968N51296Reigle Aviation South LLC · Orlando, FLBuilt 1943 · S/N 190-H0N51625Olten Elmer Jr · Wright City, MORevoked, canceledBuilt 1941 · S/N T41900N51628Manning Philip J · Melbourne, FLBuilt 1943 · S/N T43-5092N51690Laurito Patsy · Pittsburgh, PARevoked, canceledBuilt 1942 · S/N T423596N51874Patchett James J · Chapmansboro, TNBuilt 1942 · S/N T42-3699N51939National Museum Of World War II Aviation · Colorado Springs, COBuilt 1943 · S/N T43-5392N519SHAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1943 · S/N T-435954N52079American Airpower Heritage Flying Museum · Dallas, TXS/N FT-782N52159Spence Justin A · Memphis, TNBuilt 1943 · S/N T-43-5995N5215ZAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1942 · S/N 43-7098N52224Kuhn Kathleen A · Williamson, NYBuilt 1943 · S/N 292H0N52479Chase Michael A · Humboldt, TNS/N T41-940N52567Cadet Air Corp Museum · Tarkio, MOBuilt 1941 · S/N T42-1089N526PTKyler Chris K · Meridian, MSBuilt 1943 · S/N FC-47N52860Morton John C · Brewster, NYS/N 1563AEN52913Brown Charles T · Jackson, GABuilt 1942 · S/N 2893AE
Back to AD 48-45-01