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.

N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827N265PCSilver Eagle II LLC · Carson City, NVBuilt 1980 · S/N 340A-0996N2664Lcj Holdings LLC · Youngsville, LAS/N 310R0195N2664FWisconsin Aviation Inc · Watertown, WIBuilt 1980 · S/N 414A0534N2664LAce Airways LLC · Quincy, WABuilt 1980 · S/N 414A0535N2669NWilliamson Benjamin J · Morgan Hill, CABuilt 1979 · S/N 340A0735N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336N2689DRegistration Pending · Greenwood, MSRegistration pendingS/N 414A0401N2689GShandog Air LLC · Ashland, KYBuilt 1979 · S/N 414A0402N2689JFinley Taylor J · Colby, KSBuilt 1979 · S/N T18803497TN2690JDodson International Parts Inc · Rantoul, KSBuilt 1979 · S/N T18803498TN2690TN633at LLC · Punta Gorda, FLS/N 414A0408N2691YLa Paz Holdings LLC · Wetumpka, ALBuilt 1979 · S/N 414A0414N2692LInnovative Aviators LLC · Norman, OKBuilt 1979 · S/N 414A0417N2693BDiaz Charles · Ogden, UTBuilt 1979 · S/N 414A0422N2694HRockingham Carriage Services Inc · Greenland, NHS/N 4140493N2696HSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 340A0778N2696PBlue Wing Aviation LLC · Tulsa, OKBuilt 1979 · S/N 340A0779N2696UBlack Dragon Consulting LLC · Phoenix, AZS/N 340A0780N2699DN2699d Corp Trustee · Wilmington, DEBuilt 1979 · S/N 340A0787N269KTJfa Aviation Group LLC · Pompano Beach, FLBuilt 1980 · S/N TJ-324N269PCSch Aviation Inc Trustee · SporleBuilt 1979 · S/N 340A0785N269R219 Air LLC · South Bend, INBuilt 1986 · S/N 8608065N269WTWillis James A · South Jordan, UTBuilt 1972 · S/N 340-0104N26CFKustatan Leasing LLC · Nikiski, AKBuilt 1975 · S/N 20700306N26HAEpsilon Equity Partners LLC · Houston, TXS/N TJ-486N26KNSky King Aviation Inc · Weslaco, TXBuilt 1978 · S/N P21000085N26PMHill Capital Leasing LLC · Scottsdale, AZBuilt 1977 · S/N 21061791N26QRSolesbee Nathan Arthur · Anaheim, CABuilt 1979 · S/N EA-19N26RSStacey Enterprises Inc · Ogden, UTBuilt 1978 · S/N P21000153N26STSky Condor Aviation LLC · Flatwoods, WVBuilt 1974 · S/N 414-0536N2702LE D Santos & Associates LLC · Wilmington, DEBuilt 1980 · S/N 414A0608N2702VAtx Aero LLC · Austin, TXBuilt 1979 · S/N 340A0904N2704NKimberton Corp LLC · Phoenixville, PABuilt 1979 · S/N 335-0003N2704UMatheson Thomas Blair · Mandan, NDS/N 335-0005N2705LLt Aviation LLC · Plattsmouth, NEBuilt 1979 · S/N 335-0010N2706AFlhs LLC · Cedar Park, TXBuilt 1979 · S/N 335-0013N2706TDodson Internarional Parts Inc · Rantoul, KSBuilt 1979 · S/N 335-0017N2708SQuiroga Herman R · Phoenix, AZBuilt 1979 · S/N 335-0032N2708TCae Aviation LLC · Peshtigo, WIBuilt 1979 · S/N 335-0033
Back to AD 89-24-01 R1