OpenAirDocs.org
AD 89-19-04 R1

Registered aircraft · 897

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-19-04-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-19-04-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.

N958TPT&K Aviation LLC · Carrizo Springs, TXBuilt 1988 · S/N FA-172N95GADrco Aviation LLC · Matthews, MOBuilt 1993 · S/N BB1467N95LMT L Irrigation Co · Hastings, NES/N BB-1956N95TTKelly Air LLC · Cedar Falls, IABuilt 1981 · S/N BB-917N95UTPacificorp · Portland, ORBuilt 2001 · S/N BB-1759N960JPElite Medical Air Transport LLC DBA · El Paso, TXBuilt 1983 · S/N BB-1163N969MAVenable Group LLC · Tupelo, MSBuilt 1981 · S/N BB-894N96AMTexas A&M University System · College Station, TXBuilt 2000 · S/N BB-1713N96CESummit Air Leasing LLC · Portage, MIBuilt 1996 · S/N BB-1536N96WCUp And Down Aviation LLC · Carrollton, TXBuilt 1981 · S/N BB-969N970KRJetx Aviation LLC · New Bern, NCBuilt 1979 · S/N BB-454N973JHJdh-Im King Air LLC · Brownwood, TXS/N BB-1953N973KSKlotz Aviation LLC · Holcomb, KSS/N FA107N976KCTennessee River Steel LLC · Stevenson, ALBuilt 1979 · S/N BB-601N976RCSpirit Enterprises LLC · Greenwood, MSBuilt 1988 · S/N FA-141N979DKCatia Resources LLC · Garden City, TXBuilt 1985 · S/N FA-79N97EBHendee Edd C · Houston, TXBuilt 1986 · S/N FA-97N97SZSierra Zulu Aircraft Management LLC · Wilmington, DEBuilt 1983 · S/N BB1166N97WCHf Air LLC · Hattisburg, MSBuilt 1990 · S/N BB-1382N97WELawrence Aviation Inc · Austin, TXBuilt 1997 · S/N BB-1586N981BBGuardian Flight LLC · Lewisville, TXS/N BB-1960N982GAMadaket Atlas LLC · Nantucket, MABuilt 1976 · S/N BB-149N982RAInbound LLC · Overland Park, KSBuilt 1982 · S/N BB1082N982TMAt Aero LLC · Wilmington, DEBuilt 1977 · S/N BB-226N988KAAero Evanson LLC · Encino, CABuilt 1988 · S/N BB-1295N988WCE S Wagner Co · Oregon, OHBuilt 1998 · S/N BB-1622N9898Aspen Air Montana LLC · Albuquerque, NMBuilt 1998 · S/N BB1627N989LAMha Consulting LLC · Columbia, SCBuilt 1988 · S/N BB-1310N98KCBelles Aviation LLC · Missoula, MTBuilt 1976 · S/N BB172N98RADenaina Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N BB439N98VGBarron 301p LLC · Olive Branch, MSBuilt 1977 · S/N BB-252N990SHAviation Co Inc · Cheyenne, WYBuilt 1976 · S/N BC-12N990WTAmerican King Air LLC · Escalon, CABuilt 1987 · S/N FA-121N991SUAviation Enterprises LLC · Longwood, FLBuilt 1977 · S/N BB-253N991WWAssured Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1158N994MLGc Air LLC · Knoxville, TNBuilt 1981 · S/N BB-994N995TXGarbar Organization LLC · Duncan, SCBuilt 1982 · S/N BB1027N997LMLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1976 · S/N BB217N998AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1988 · S/N BB-1309N998BWDuplin Aero LLC · Wallace, NCBuilt 1988 · S/N FA-149N999DTX Stallion Ventures LLC · Jacksonville, TXBuilt 1976 · S/N BB-138N999LMN313ba Ownership LLC · Kaukauna, WIBuilt 1989 · S/N FA178N999MMNorth Lincoln County Hospital District DBA · Afton, WYBuilt 2007 · S/N BB-1997N999TBHoneywell Aerospace US LLC · Phoenix, AZBuilt 2000 · S/N BB-1738N999VBJet Air Inc · Galesburg, ILBuilt 1995 · S/N BB-1506N9GAN9ga Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1719N9WRJ P W Investments Inc · Frederick, MDBuilt 1981 · S/N BB-913
Back to AD 89-19-04 R1