OpenAirDocs.org
AD 89-24-01 R1

Registered aircraft · 4,242

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.

N6557BFangio Mark · Mckinney, TXBuilt 1978 · S/N 21062786N6561CTrtc Aviation LLC · Byron Center, MIBuilt 1977 · S/N 414A0014N6562YKp Builders Inc · Pittsburgh, PABuilt 1981 · S/N 21064440N6567YMoeller Gerhard Walter · Goshen, OHBuilt 1981 · S/N 21064442N6568XBarnes Inc · Lewiston, IDBuilt 1980 · S/N U20605950N656MCMcintosh Justin W · Joshua, TXBuilt 1978 · S/N 21063111N6572YMoss G B · Bakersfield, CABuilt 1981 · S/N 21064444N6573EZxtair LLC · Janesville, MNS/N 1942SVN6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020N6580XSouthwest Aerial Survey LLC · Carlsbad, CABuilt 1983 · S/N EA-341N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125N6582PGrand High Way LLC · Gallatin, TNBuilt 1978 · S/N P21000191N6582XMclean Bruce R · Napa, CABuilt 1980 · S/N U20605958N6584NHartmann Wayne E · Hill City, SDBuilt 1978 · S/N 21063112N6585XNorthbay Consulting LLC · Bellevue, WABuilt 1983 · S/N EA-340N6586WMair LLC · Lenexa, KSBuilt 1982 · S/N P21000800N65873Carpenter Steve · Batesville, ARBuilt 1983 · S/N EA-342N6588XPc Rental LLC · Ely, MNBuilt 1980 · S/N U20605962N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429N6591NRickey James R · Hanford, CAFirst renewal noticeBuilt 1978 · S/N 21063114N6593WSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N P21000801N6594CMaiden Assets LLC · Norfolk, VABuilt 1980 · S/N 335-0056N6597CHai Services Inc · Haltom City, TXBuilt 1978 · S/N 414A0028N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092N65MJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N TJ-487N65RPE-Co Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0287N6602CSnip Robert C · Telluride, COBuilt 1980 · S/N 21063926N6606YBlackwell Benjamin D · Scottsdale, AZBuilt 1981 · S/N 21064457N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804N660CABank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 402C0406N660R660 Romeo LLC · Tulsa, OKBuilt 1968 · S/N D-8826N6611ESpirit Of Faith Family Church · Cedar Rapids, IAS/N EA-347N6614CBg Air Corp · Wilmington, DEBuilt 1978 · S/N 414A0032N6614YBoots LLC · Clay Center, KSS/N 21064460N6617CN6617c Inc · Calumet City, ILBuilt 1980 · S/N 21063933N6621AJc Investors Group LLC · Coral Springs, FLBuilt 1979 · S/N 21063559N6622CMidnight Flight LLC · Wells, TXBuilt 1980 · S/N 21063936N6622YSierrakilo LLC Trustee · Lewes, DES/N 21064464N6631CD Porter Enterprises LLC · Dickinson, NDBuilt 1978 · S/N 414A0038N6634PAviation-Avsec Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1978 · S/N P21000194N6638NIsr Aviation LLC · Wilmington, DEBuilt 1978 · S/N 21063129N663AAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C-0123N6640CGospel Ministries International Inc · Collegedale, TNBuilt 1978 · S/N 414A0044N6641TAx3 LLC · Decatur, TXBuilt 1980 · S/N EA-68N6641WLandlund Flying LLC · Oroville, CABuilt 1982 · S/N EA-274N6643EReynolds Ronnie · White Hall, ARBuilt 1979 · S/N TJ-215N6643PRobert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1979 · S/N EA-45N6644QLomakin Anatol · Lincoln Park, NJBuilt 1974 · S/N 414-0543N6646ZN1437a LLC · Delray Beach, FLBuilt 1981 · S/N TJ-203
Back to AD 89-24-01 R1