AD 43-07-01

Registered aircraft · 174

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:43-07-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:43-07-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.

N48144Farley 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-3530N49481Fleeman 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-1968N51625Olten 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-7098N52479Chase 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 2893AEN53019Pflegl Henry A · Oregon City, ORBuilt 1943 · S/N T43-5050N53279Leverich James E · Pampa, TXBuilt 1943 · S/N T43-5589N53288Razorback Eaa 1388 · Pine Bluff, ARS/N T-42-1491N53656American Airpower Heritage Flying Museum · Dallas, TXS/N 6533AEN53660Moon Brittany Lozier · Noblesville, INS/N T40-191N53727Oaks Randall K · Oxnard, CAS/N T435144N53848Chumbley Eric M · Alvaton, KYBuilt 1943 · S/N T43-5306N53929Wynecoop Shawn R · Bowbells, NDBuilt 1942 · S/N T423765N53953Wilson Tommy · Greenleaf, IDBuilt 1942 · S/N T41-1342N54201Casa Acquisitions LLC · Winter Haven, FLS/N T42-1496N54254Craig Robert A · West Chester, PABuilt 1941 · S/N T-42-1831
Back to AD 43-07-01