OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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:96-24-17-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-17-R1')
  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.

N1434KRobertson Claude A · Phoenix, AZS/N 4161N1435BHarpham Verdon R · Boyden, IARegistration revokedBuilt 1948 · S/N 6062N1435KAmmons H B · Sanford, NCRegistration revokedBuilt 1946 · S/N 4162N1439KEigsti Rodney E · Friend, NES/N 4166N1440KTucker James M Jr · Headland, ALBuilt 1946 · S/N 4167N1441BRon Alexander Youth Aviation Program · Williamson, GABuilt 1948 · S/N 6068N1442BWilliams Michael · Hartsville, INBuilt 1948 · S/N 6069N1442KGibbs Lena R · Eagle River, AKBuilt 1946 · S/N 4169N1444BPoklar Norman · Mount Orab, OHS/N 6071N1445KHutson David A · Northport, ALBuilt 1946 · S/N 4172N1447BSmith Shawn Benjamin · Salem, ORBuilt 1948 · S/N 6074N1448BCook David L Trustee · Owasso, OKBuilt 1948 · S/N 6075N1448KBentch James R · Lincoln, MOBuilt 1946 · S/N 4175N1449BZander Walter W · Glendora, CABuilt 1948 · S/N 6076N144BRLeighton Michael L · Saco, MEBuilt 1946 · S/N 3695N1451KAnderson Mark A · Bates City, MOS/N 4178N1453BManning Jerry C · Lufkin, TXBuilt 1948 · S/N 6080N1454BWithrow Thomas E · Lewisburg, WVS/N 6081N1455BMartin Rand E · Lake Stevens, WAS/N 6082N1456BGregory Norbert L · Farmington, MNBuilt 1948 · S/N 6083N1458BPerkins William Barry · Monterey, CABuilt 1948 · S/N 6085N1459BDavis Jeffrey S · Oregon City, ORBuilt 1948 · S/N 6086N1463BRegistered aircraftRegistration pendingBuilt 1945 · S/N 6090N1463KAasness Todd D · Fresno, CABuilt 1946 · S/N 4190N1467BNielsen Jeffrey S · Ashland, ORS/N 6094N1471KBarnes Sammy Dean · Taylorsville, NCBuilt 1946 · S/N 4198N1474BSanderson David K · Scotts Valley, CABuilt 1948 · S/N 6101N1477KRegistration Pending · Hamilton, TXRegistration pendingBuilt 1946 · S/N 4204N1480BN1480b LLC · Wentzville, MOBuilt 1948 · S/N 6107N1486KKruckeberg Leroy A · Sanford, NCBuilt 1946 · S/N 4213N1490BEspinoza Cheryl · Littleton, COBuilt 1948 · S/N 6117N1490KBell Gary W · Jones, OKS/N 4217N1492BRegistration Pending · Castle Pines, CORegistration pendingS/N 6119N1505BKulle William T · Springfield, MABuilt 1948 · S/N 6132N1512BBradley Larry A · Lafayette, CAS/N 6139N1520BRegistration Pending · Fort Worth, TXRegistration pending, canceledBuilt 1948 · S/N 6147N1521BAnderson Andrew A · Bates City, MOS/N 6148N1522BHetrick Bros Inc · Orovada, NVBuilt 1948 · S/N 6149N1528BShelby Aero Club LLC · Shelbyville, INBuilt 1948 · S/N 6155N1529BSale Reported · Kennett Square, PASale reportedBuilt 1948 · S/N 6156N1530BAsleson James E · Intl Falls, MNBuilt 1948 · S/N 6157N1531KMckinney Timothy Scott · Guthrie, OKS/N 4258N1533BAirpower Museum Inc · Ottumwa, IABuilt 1948 · S/N 6160N1533KHancheck Paul C · Wadsworth, OHBuilt 1946 · S/N 4260N1534BMacmahon Ian L · Osteen, FLBuilt 1948 · S/N 6161N1534KShannon Randal S · Drexel, MOBuilt 1946 · S/N 4261N1535KKeenan Cheryl L · Saratoga, CABuilt 1946 · S/N 4262N1537KSwart Wayne C · Rescue, CABuilt 1946 · S/N 4264N1538BShiffer Lyle J · Waterford, MIBuilt 1981 · S/N 6165N1540BTiberg Robert E · Sparta, TNBuilt 1948 · S/N 6167
Back to AD 96-24-17 R1