OpenAirDocs.org
AD 72-24-02

Registered aircraft · 4,693

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

N1003CRogers Justin T · Kalispell, MTS/N 28-22741N1004XRegistration Pending · Yucaipa, CARegistration pendingBuilt 1975 · S/N 28-7525256N100WWSwearengin David · Lula, GABuilt 1967 · S/N 28-23611N101JDresden Leasing LLC · Sheridan, WYBuilt 1965 · S/N 28-20898N101MSKoenig William J · Benedict, MDS/N 28-7125519N101NL1st American Aviation Inc · North Miami, FLBuilt 1967 · S/N 28-23419N101RMWarren Isaac J · Tucson, AZBuilt 1965 · S/N 28-21184N1020DChimera Air Inc · Maumee, OHBuilt 1974 · S/N 28-7425251N1025XCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1975 · S/N 28-7525261N1026HNeedham John A · Southington, CTBuilt 1973 · S/N 28-7325489N1027BMarshall Loraine · Cincinnati, OHBuilt 1977 · S/N 28-7725246N102FBWelch Richard J · Niceville, FLBuilt 1969 · S/N 28-26508N102LCMy Technology Services LLC · Miami, FLBuilt 1967 · S/N 28-22860N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266N1051XNormand Glendon · Marksville, LABuilt 1975 · S/N 28-7525268N1067QHard Rock Inc · Purcell, OKBuilt 1977 · S/N 28-7725179N106MSKundel Richard · Cedar Rapids, IABuilt 1974 · S/N 28-7525063N1071XPeter Prince Aviation Center LLC · Milton, FLBuilt 1975 · S/N 28-7525274N1072QCoastal Air Inc · Groton, CTBuilt 1977 · S/N 28-7725180N1079HJaremus Kent M · Olathe, KSS/N 28-7725131N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118N10805Hill Ag-Air LLC · Pocatello, IDS/N 28-22677N1080XRegistration Pending · Houston, TXRegistration pendingS/N 28-7525278N1092TH4s Aviation LLC · Longview, TXS/N 28-25565N1096TEvans Charles B · Benbrook, TXS/N 28-26284N1097THorizon Aviation LLC · Brooks, GABuilt 1969 · S/N 28-26287N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482N1104HSkydance Aviation LLC · Chesapeake, VAS/N 28-7725132N111FRAirward Inc · Novato, CABuilt 1972 · S/N 28-7325055N1122ACox Abraham · Key West, FLBuilt 1968 · S/N 28-25081N1123WThiel Jonathan Ronald · Billings, MTS/N 28-771N112JMGuzman John · China Spring, TXBuilt 1975 · S/N 28-7525187N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295N117DWFerrand Kathy M · Cornelia, GABuilt 1973 · S/N 28-7325669N117MTHinkle Robert J · Caldwell, IDS/N 28-21374N1184DZwick Noah Geary · Dunkirk, MDBuilt 1967 · S/N 28-23130N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406N11GERusso James F · Liberty, SCBuilt 1972 · S/N 28-7325081N11GKBaden Michael · Waxhaw, NCS/N 28-23403N1203TProfessional Locators & Acquisition Specialists Ll · Severance, COBuilt 1972 · S/N 28-7225420N1204THigh Sky LLC · Ellensburg, WABuilt 1972 · S/N 28-7225421N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422N1213TDyer Gary T · Reno, NVS/N 28-7225423
Back to AD 72-24-02