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.

N355FRD Hadjidemetriou Aviation Services Corp · Wilmington, DEBuilt 1975 · S/N 31P7530002N356DBCaldwell Island LLC · Sherborn, MABuilt 1978 · S/N 31-7852056N357SAFox Aircraft LLC · Wasilla, AKBuilt 1980 · S/N 31-8052162N3582PAir Arctic Inc · Fairbanks, AKS/N 31-8052103N35834Carto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052115N35841Flyingvine LLC · Gilford, NHBuilt 1980 · S/N 31-8012054N3586DDurrell Lee W · Memphis, TNBuilt 1980 · S/N 31-8012065N3587PMsm587p LLC · Jericho, NYS/N 31-8052120N35890Ja Aero LLC · Chicago, ILBuilt 1980 · S/N 31-8052139N3589BAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052134N3589XMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052138N3590BTranquil Air LLC · Lighthouse Point, FLBuilt 1980 · S/N 31-8052143N3590DSale Reported · Xxx, OKSale reported, canceledBuilt 1980 · S/N 31-8052144N359CMarc Inc · Bolton, MSS/N 31-7912109N359RXD-Kal Leasing LLC · Meadowbrook, WVS/N 31-8012030N35RDIngersoll Grove LLC · Springfield, MABuilt 1977 · S/N 31-7852039N369KJGrace Aire Inc · Corpus Christi, TXBuilt 1978 · S/N 31-7852108N36PBMarin Pacific International LLC · Apple Valley, CABuilt 1973 · S/N 31-7405128N371MCSale Reported · Palm City, FLSale reportedS/N 31-7405409N371WAAkro Attitudes Inc · Lighthouse Point, FLBuilt 1976 · S/N 31-7612042N3744UCristiani Sandra Elizabeth · Miami, FLBuilt 1981 · S/N 318312006N3746PSale Reported · Fort Lauderdale, FLSale reported, canceledS/N 31-7752095N376DGClark Anthony · Augusta, KSBuilt 1976 · S/N 31P-7630015N376NCLima Delta Company Trustee · New Castle, DEBuilt 1977 · S/N 31-7852048N378MMBento De Deus Amarildo · Margate, FLBuilt 1978 · S/N 31-7812118N37PJDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N 31T-7904003N385RMG Force Air LLC · Columbus, OHBuilt 1978 · S/N 31-7852125N38KCChanney Aviation Group LLC · Las Vegas, NVBuilt 1983 · S/N 31-8352033N38MCGulf Air Aviation · Wilmington, DES/N 31-7405476N38TWHones William G · Normandy Park, WAS/N 31T-8104008N390JDSevern Aeronautics Ltd · Annapolis, MDBuilt 1978 · S/N 31T-7820061N390JPLucky7 Air LLC · Lenoir, NCBuilt 1981 · S/N 31T-8166027N396JHGoode Todd · Nampa, IDS/N 31T-7920087N398SPHillcrest Aviation LLC · Clear Lake, IAS/N 31T-8104027N39CACannondale Aviation L L C · Wilton, CTS/N 31-8212030N39EHAir Travel Management Of Delaware LLC · Wilmington, DEBuilt 1978 · S/N 31T-7920020N39HASmc Ltd · Somerset, WIS/N 31-497N39TLDunamis Resources LLC · Lewes, DES/N 31T-8104012N3RKCorinthian LLC · Southgate, MIS/N 31T-8166022N3VMAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1973 · S/N 31-7305069N400CMAerial Surveys International LLC · Watkins, COBuilt 1976 · S/N 31T-7620040N400HMBarneys Services Inc · Newton, IABuilt 1979 · S/N 31-8052030N400RAJacko Josh E · Anchorage, AKBuilt 1974 · S/N 31-7405167N400WSHatbright Farm LLC · Wilmington, DEBuilt 1981 · S/N 31T-8166044N401VAPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1982 · S/N 31T-8275001N4023Maighnath Melissa · Jamaica, NYS/N 31-8152067N403MCorporate Aircraft Group LLC · Annapolis, MDS/N 31T-8004033N403RGGkids Holdings LLC · New York, NYS/N 31-7952219N4042MLinville Air LLC · Denver, NCBuilt 1980 · S/N 31-8112014N4043MPremier Air Charters Inc · Coram, NYBuilt 1980 · S/N 31-8152001
Back to AD 93-24-02 R1