OpenAirDocs.org
AD 93-24-02 R1

Registered aircraft · 806

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:93-24-02-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:93-24-02-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.

N642WAGunnslinger Air LLC · Destin, FLBuilt 1979 · S/N 31-7952084N643SCRegistered aircraftBuilt 1970 · S/N 31P-7N645SCDeaton Dennis · Glen Allen, VAS/N 31P-22N646SCRegistered aircraftBuilt 1970 · S/N 31P-33N648SCDeaton Dennis · Glen Allen, VAS/N 31P-7300143N649SCDeaton Dennis · Glen Allen, VAS/N 31P-7400184N64APD&N Holdingsinc · Boca Raton, FLBuilt 1974 · S/N 31-7405178N652PLN652pl LLC · Saint Joseph, MOBuilt 1980 · S/N 31-8052159N652SCSale Reported · Glen Allen, VASale reportedBuilt 1970 · S/N 31P-14N653SCDeaton Dennis · Glen Allen, VAS/N 31P-25N6598LAtmospheric Corrosion Specialists Inc · Mechanicsburg, PABuilt 1969 · S/N 31-483N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071N65CMCapital City Jet Center Inc · Somerset, OHBuilt 1978 · S/N 31-7852077N65GSCheyenne Air LLC · Charleston, WVBuilt 1983 · S/N 31P-8414016N660ACSmooth Air LLC · Richboro, PABuilt 1977 · S/N 31-7752142N662CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 318052014N668CWPrecision Air Inc · Anchorage, AKBuilt 1980 · S/N 31-8052176N66AEAndreassi LLC · Bluffton, SCBuilt 1974 · S/N 31-7405187N66ATDeer Elm Aviation LLC · Owens Cross Roads, ALBuilt 1975 · S/N 31-7552042N66BGAlaska Island Air Inc · Togiak, AKS/N 31-8252032N66TBTurner Brothers LLC · Middleboro, MABuilt 1983 · S/N 31-8452014N66TWRolfe Bangerter Aviation LLC · Murray, UTS/N 31T-8004030N676ARBlackdog Air LLC · Belton, SCS/N 31-8152182N676SAVincennes University · Indianapolis, INBuilt 1979 · S/N 31-7912122N67DWDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 31T-7620041N6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1978 · S/N 31-7812003N68BJCrownair LLC · Mansfield, PABuilt 1979 · S/N 31T7920029N68WCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1973 · S/N 31P-7400188N696SGAtl Pilot LLC · Senoia, GABuilt 1984 · S/N 31-8452018N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408N6ARBluewater Airmotive Corporation · Wilmington, DEBuilt 1973 · S/N 31-7300914N6GRMarc Inc · Bolton, MSS/N 31-7752130N700CMoss Donald · Pinecrest, FLBuilt 1974 · S/N 31-7405497N700RDPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1985 · S/N 31T5575001N703XPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 31-7912090N70543Tk Group Holdings LLC · Wilmington, DEBuilt 1976 · S/N 31-7612029N707HHT And L Restaurant Groups Aviation LLC · Hattiesburg, MSS/N 31-8112067N708SAOlivier Seth Nicholas · Baskin, LABuilt 1981 · S/N 31T-8104042N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030N70GWAncient City Capital LLC · Saint Augustine, FLBuilt 1980 · S/N 31T-8104004N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208N70TWGunter Lennon DBA · Tabernacle, NJS/N 31T-7904043N710DGNavajo Holdings LLC · Naples, FLS/N 31-7305017N710JJLachatel Sisters Boutique Inc · Miami, FLBuilt 1976 · S/N 31P-7730002N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086N711ERCommunications Laboratories Inc · Melbourne, FLBuilt 1981 · S/N 31T-8104056N711MAKiddie Hawk Air Academy · Littleton, COS/N 31-7652159N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138
Back to AD 93-24-02 R1