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.

N829BAAdaptive Resources Inc · Fort Morgan, COBuilt 1983 · S/N P21000819N829CGRegistered aircraftBuilt 1986 · S/N 4608029N82AWQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 414A0064N82GBAmerican Aviation Inc · Page, AZBuilt 1978 · S/N 340A0463N82TAJanes Paul A · Ontario, ORBuilt 1968 · S/N 402-0156N82TRExecutive Autopilots DBA · Sacramento, CABuilt 1972 · S/N 414-0273N8300ZWillowridge Farm · Winchester, KYBuilt 1993 · S/N EA-551N830BJElm III Operating Company LLC · Edmond, OKBuilt 1979 · S/N 340A0738N830TPValhalla Partners LLC · Atlanta, GABuilt 1984 · S/N 46-8408015N830TTThuen Douglas · Andover, NJBuilt 1972 · S/N 3400186N831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 414A0340N831GETs&L Aircraft LLC · Alexandria, MNS/N TJ-293N831JBDjd Properties LLC · Victoria, TXBuilt 1980 · S/N TJ-279N831RRFresh Farms Inc · King City, CABuilt 1986 · S/N 21064994N831WCEpic Vibes Consulting Group Lp · Princeton, NJS/N 414-0467N8338HBayviewer LLC · Sarasota, FLS/N EA-399N833RTNash LLC · Carbondale, ILBuilt 1982 · S/N P21000809N833TXN833tx LLC · Little Rock, ARBuilt 1978 · S/N TJ-153N8352QUnited Indian Missions DBA · Tucson, AZBuilt 1976 · S/N U20603213N8356NNielson Frederick P · Mesquite, NVS/N D-8744N837MLBombero Aviation LLC · Childress, TXBuilt 1994 · S/N EA558N8386M213tz LLC · Hailey, IDBuilt 1978 · S/N U20604520N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578N83DLake Placid Flying Service Inc · Lake Placid, NYBuilt 1981 · S/N 414A-0615N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285N83JTLewis Thomas · Belton, TXBuilt 1976 · S/N 414-0835N83PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0350N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269N840DElusive Aviation Inc · Pflugerville, TXBuilt 1987 · S/N 4608076N8424WExtra Equipment Inc · Stuart, FLBuilt 1979 · S/N 21063732N842BESparrow Holdings LLC · Irvine, CABuilt 1984 · S/N EA-432N843YTTrue Drilling LLC · Casper, WYBuilt 1979 · S/N 21063334N8442QFerguson John W · Edwardsburg, MIBuilt 1976 · S/N U20603301N845LMarshall Timothy Trustee · Tucson, AZBuilt 1982 · S/N 340A1511N8462QPahrump Aviation LLC · Las Vegas, NVS/N U20603320N8463QSmith James M · Star, IDBuilt 1976 · S/N U20603321N8475MSpess Drilling Co Inc · Cleveland, OKBuilt 1977 · S/N 21062046N8479QLake Airways Management LLC · Hazelhurst, WIBuilt 1976 · S/N U20603337N84BTSoltani Ebrahim · Palos Verdes Est, CABuilt 1990 · S/N EA-509N84CGGuardian Angel Homes LLC · Hayden, IDBuilt 1981 · S/N 340A1274N84DAVoorhees Investments Inc · Costa Mesa, CABuilt 1980 · S/N 414A0519N84HCJeffcoat Roy B · Anderson, SCBuilt 1976 · S/N 340A0052N84JBPremise Aviation LLC · Elizabeth, COS/N 340A1009N84PECarosso Kevin V · Santa Cruz, CABuilt 1984 · S/N TJ-470N84PRSkov Equipment Co · Fabens, TXBuilt 1979 · S/N 414A0213N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867N84TTRenda Michael A · Sunrise Beach, MOBuilt 1962 · S/N D-6942N8506QBell Robert C · Colby, KSS/N U20603363N8516GTri-State Management Corp · Thomasville, GABuilt 1979 · S/N 340A0702
Back to AD 89-24-01 R1