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.

N357JTClub Bo A36 LLC · Helena, MTBuilt 1979 · S/N EA-51N357MMClark Melvin G · Sunnyvale, TXBuilt 1985 · S/N 46-8508092N35877Turbine Conversions Ltd · Nunica, MIBuilt 1975 · S/N U20602777N35909Flight1 Hsw LLC · Norwood, COBuilt 1975 · S/N U20602792N35932Tmzk Holdings LLC-1 · North Fort Myers, FLBuilt 1975 · S/N U20602808N35957Cortez Flying Service Inc · Cortez, COBuilt 1975 · S/N U20602829N35AUHat Creek Construction & Materials Inc · Burney, CABuilt 1985 · S/N EA-448N3605PSmith Bryan · Wenatchee, WABuilt 1978 · S/N P21000040N360NEGoldrivet · Stateline, NVBuilt 1980 · S/N EA-128N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565TN361GCFff Leasing LLC · Dover, DES/N 414-0616N361KWFliteco Holdings LLC · Lewes, DEBuilt 1981 · S/N EA-264N3636TFortier Stanley · Chico, CAS/N EA-18N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N3663KEvans And Evans Properties Inc · Santa Cruz, CABuilt 1980 · S/N EA-84N3664GMarshmont Aviation LLC · Greenville, SCS/N TJ-280N36664Strauss Steven Trustee · Tempe, AZBuilt 1980 · S/N EA-89N3668DLkj Holdings LLC · Amarillo, TXS/N EA-92N366PWEuroaviation Inc Trustee · KematenBuilt 1992 · S/N EA-530N3670EFresh-Pic Harvest Inc · La Quinta, CABuilt 1980 · S/N TK-124N3671FHenson Ronald E · Bonita Springs, FLS/N EA-94N36847Thrash Howard G II · Lubbock, TXBuilt 1980 · S/N EA-115N3684YBluebird Holdings LLC · Morris, MNFirst renewal noticeBuilt 1980 · S/N TJ-298N3685WJewell Warren · Seattle, WABuilt 1980 · S/N EA-113N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N36877Stilwell Aviation LLC · Stilwell, KSBuilt 1980 · S/N EA-119N36884Main Aviation Inc · Visalia, CABuilt 1980 · S/N EA-121N36885Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 340A0681N36887Aa Aircraft Adventure LLC · Joplin, MOBuilt 1982 · S/N 414A0835N36908Williams D Eric · Palm Springs, FLBuilt 1980 · S/N 402C0313N3690DR B M Corporation · Cropwell, ALBuilt 1980 · S/N TJ-306N3690NDetraglia Michael C · Canandaigua, NYBuilt 1980 · S/N EA-123N36911Hyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0314N36939Holtzen Farms Inc · Jerome, IDBuilt 1980 · S/N EA-129N36958N36zz LLC · Parkland, FLBuilt 1980 · S/N EA-137N36961Alpha 414a LLC · New Smyrna Beach, FLBuilt 1980 · S/N 414A0494N3696LP51d Mustang LLC · Bigfork, MTBuilt 1980 · S/N TJ-310N3699GInternational Aerospace Solutions LLC · Jupiter Inlet, FLBuilt 1980 · S/N EA-151N369HCCornerstone Mapping Inc · Roca, NEBuilt 1980 · S/N 21064049N36AJFurst A J · Coral Gables, FLBuilt 1992 · S/N EA-532N36CGDay Edwin Daniel · Richland, WABuilt 1969 · S/N 310P0075N36DGRegistered aircraftBuilt 1977 · S/N 340A0331N36HPNyack Inc · Emigrant Gap, CABuilt 1984 · S/N EA-423N36HWHw Inc · Omaha, NEBuilt 1980 · S/N EA-166N36KPAir Lease Inc · Bridgeport, WVBuilt 1989 · S/N EA-495N36LLBeech Bums Aviation II LLC · Linden, MIBuilt 1980 · S/N EA-155N36LMN36lm LLC · Spicewood, TXS/N EA-67
Back to AD 89-24-01 R1