AD 46-24-01

Registered aircraft · 1,529

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:46-24-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:46-24-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.

N1342MSkys Unlymited Inc · Wilmington, DEBuilt 1943 · S/N 75-5188N1343MMehrer Fritz J · Oceanside, CAS/N 75-8445N1344MJohnson Lawrence F · Colville, WAFirst renewal noticeBuilt 1943 · S/N 758325N1344VPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 1943 · S/N 75-8806N1347VHolder James C · Leonard, TXBuilt 1943 · S/N 75-8490N1357NGibbs Robert I · Ravenswood, WVBuilt 1943 · S/N 75-5423N1358MGottron Gregory · Williamson, GABuilt 1941 · S/N 75-1229N1359NWiplinger Robert · Inver Grove Height, MNBuilt 1945 · S/N 75-5738N1361NZiebarth W Richard · Powell, OHS/N 75-7691N1363VLil Dawg Aviation LLC · Wilmington, DES/N 75-8704N1366VCushing Sean M · Howell, MIS/N 75-8664N1370VBald Eagle Aviation LLC · West Chester, PABuilt 1943 · S/N 75-5185N1371VWilson Archie C · Hernando, FLBuilt 1943 · S/N 75-8107N13787Yandik Stephen E · Hudson, NYBuilt 1942 · S/N 75-3141N1379VBallard Rickey G · Buckeye, AZBuilt 1943 · S/N 75-8153N1383VNorthington Neill · Fredericksburg, TXBuilt 1943 · S/N 75-8667N1387VAmerican Airpower Heritage Flyingmu · Dallas, TXBuilt 1945 · S/N 75-8291N1390NOnstott Norman V · Mt Pleasant, MIBuilt 1955 · S/N 75-5505N13SSSmith Sharon D · Deridder, LABuilt 1942 · S/N 75-5337N14101Weaver Clifford A · East Berlin, PABuilt 1943 · S/N 75-4402N1414MCruz Glenn A · Star, IDS/N 75-5230N1423MPeters D R II · Laurel, MSS/N 75-8190N1431CJensen Aviation Inc · South Haven, MIBuilt 1941 · S/N 75-1702N1434MEastern Stearman Inc Trustee · Leesburg, VABuilt 1947 · S/N 75-8261N143JSMcclain Aviation LLC · Roanoke, TXBuilt 1943 · S/N 75-5556N145NPelton Jack J · Wichita, KSBuilt 1942 · S/N 75-4396N146CMMartin James D · Leesburg, FLBuilt 1942 · S/N 75-3268N149WAvakian Haig · Vineland, NJS/N 75-5252N14GCJr Stearman LLC · Fairfield, CABuilt 1941 · S/N 75-6503N1522MRopkey Armor Museum Inc · Indianapolis, INS/N 75-8343N1559MCarlton John B · Lenoir, NCBuilt 1941 · S/N 75-2703N1560MPrice William B · Lamar, SCS/N 75-4953N15GCMartinez Juan R · Secaucus, NJS/N 75-2164N15LZZambrano Mario · Austin, TXBuilt 1945 · S/N 755460N1612MJohnson Jeffrey · Sanger, TXBuilt 1943 · S/N 75-8593N1617MAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 75-8498N161SBMak Ventures LLC · Morriston, FLBuilt 1943 · S/N 75-8209N1626MOgr Air LLC · Erwinna, PABuilt 1943 · S/N 75-8441N1631MAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 75-8509N1634MJohnson James K Jr · Sandy Valley, NVBuilt 1943 · S/N 75-7206N1636MAshley James M · Greenwood, SCS/N 75-7314N1640MStas Stefan J · Clifford, PABuilt 1943 · S/N 75-5214N1658MHill George R · Carriere, MSBuilt 1942 · S/N 75-5173N16BPN16bp LLC · Mesa, AZBuilt 1942 · S/N 75-4350N16CCWhitney Frederick C · Hampton, NJBuilt 1940 · S/N 75-623N16PEAircraft Partner Holdings Inc Trustee · BerlinBuilt 1941 · S/N 75-871N16SDS Dacy Enterprises Inc · Harvard, ILS/N 75-6600N16XMid Continent Aircraft Corp · Hayti, MOBuilt 1941 · S/N 75-2192N1702MSouth Delta Aviation LLC · Grace, MSBuilt 1943 · S/N 75-8558N1704MPlane Fun Inc Tr Trustee · Snellville, GABuilt 1943 · S/N 75-8595
Back to AD 46-24-01