OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,243

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:89-24-01-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:89-24-01-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.

N180BADavis Robert D · Camas, WAS/N 18052419N1811DRegistration Pending · Kennedale, TXRegistration pending, canceledBuilt 1981 · S/N EA-237N1812QLiv2fly LLC · Grand Junction, COBuilt 1975 · S/N U20602936N1814EErda LLC · Wilmington, DEBuilt 1981 · S/N EA-241N1815LEagles Rise Aviation LLC · Wales, MAS/N TJ-63N1817AKlinefelter Kristopher J · Phoenix, AZBuilt 1981 · S/N EA-243N1817ZOrr Lynn E · Fredericksburg, OHBuilt 1981 · S/N TJ-386N1819MDjb Asset Management LLC · Oakdale, CABuilt 1981 · S/N EA-245N181JRCavu Clearing LLC · Palm Coast, FLBuilt 1982 · S/N TJ-363N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408N1821EHth Companies Inc · Union, MOBuilt 1979 · S/N 310R1581N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N1830ZJaju Aviation Inc · Abilene, TXBuilt 1981 · S/N TJ-379N1835SEagles Flying Club Inc · San Francisco, CABuilt 1984 · S/N EA-419N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433N1843LRegistered aircraftS/N TJ-65N1847HQuantum Fly Corp · Boca Raton, FLS/N TK-145N18499Austin Aviation LLC · Boise, IDBuilt 1983 · S/N EA-362N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302N1850JWailea Aircraft LLC · Kamuela, HIBuilt 1981 · S/N EA-268N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N185MTMarsh Douglas C · Omak, WABuilt 1975 · S/N 18502672N185RAA-T Enterprises Ltd · Three Forks, MTBuilt 1967 · S/N 185-1209N1865LLiberty Partners Inc · Okmulgee, OKS/N TK-14N1879LN1879l LLC · Missoula, MTBuilt 1976 · S/N TK-13N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N189FTeag Leasing LLC · Edmonds, WABuilt 2001 · S/N EA-680N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N18DLBelov Mikhail · Greenwood Village, COBuilt 1977 · S/N 310R1251N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664N1908GAir Z Flying Service Inc · Richmond Heights, OHBuilt 1974 · S/N 310R0055N190CCWayside LLC · Wilmington, DEBuilt 1984 · S/N 46-8408045N1915WPasha Mohammad A · Muscatine, IABuilt 1971 · S/N 310Q0429N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496N192CMFriehe Berend · Moses Lake, WABuilt 1981 · S/N U20606160N193TTBgiii Air LLC · Tampa, FLBuilt 1976 · S/N 21061601
Back to AD 89-24-01 R1