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.

N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854N6650HN6650h LLC · Edmond, OKBuilt 1982 · S/N EA-318N66529King Warren D · Bend, ORBuilt 1979 · S/N EA-8N6652JAir Chairs LLC · Austin, TXBuilt 1979 · S/N EA-11N6654LRomeo Air LLC · Missoula, MTS/N EA-50N66568Trapp Aviation Ltd · Lebanon, OHS/N TK-105N6657TPilot-Ready LLC · Lime Springs, IABuilt 1979 · S/N EA-22N66585Haines Jay A · Summerland Key, FLBuilt 1983 · S/N EA-353N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222N665SCGold Star Beacon LLC · Sarasota, FLBuilt 1975 · S/N 340A0006N6661NSmith Joel L · Cedar Park, TXBuilt 1978 · S/N 21063137N6664LTt Aviation LLC · Oxnard, CABuilt 1979 · S/N EA-20N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227N6667NSmith William F · Hindsville, ARBuilt 1978 · S/N 21063141N6669XEdm-Van LLC · Maple Lake, MNBuilt 1979 · S/N TK-108N6670GSterling Park Corp · Ashland, KYBuilt 1979 · S/N EA-26N6672CBayview Direct LLC · Dover, DEBuilt 1978 · S/N 414A0053N6674CAire Tracks Corp · Wilmington, DEBuilt 1980 · S/N 335-0058N6675ATool Equipment Leasing Corporation · Bethany, OKBuilt 1979 · S/N EA-30N6675YField Inspection LLC · Brawley, CABuilt 1980 · S/N TJ-254N6677BHess Chad · Boise, IDBuilt 1978 · S/N 21062816N6677LAeropacific Consulting LLC · Reno, NVBuilt 1979 · S/N TJ-209N6677RTre Aviation Corp · Wilmington, DES/N 21059654N66784Grimm Phillip H · Draper, UTBuilt 1979 · S/N EA-34N6678C678c LLC · Pensacola Beach, FLBuilt 1979 · S/N TJ-235N6678YNewhouse Eric · Corrales, NMBuilt 1983 · S/N EA-360N667PCMattie Joseph · Ester, AKBuilt 1984 · S/N 46-8508001N6680BBush Douglas B · Santa Rosa Beach, FLBuilt 1978 · S/N 21062818N6680GHorst Commercial Ventures LLC · Sanger, TXBuilt 1979 · S/N TJ-236N6683NLn Skies LLC · Streetman, TXBuilt 1979 · S/N TJ-239N6683YGate Post Aviation LLC · Woodbury, CTBuilt 1979 · S/N TK-111N66844Munden Paul M · Amarillo, TXS/N EA-364N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6687DVolare Flight Service LLC · Pine Village, INBuilt 1983 · S/N EA-365N66885Turn Key Construction Services Inc · Lincoln, CAS/N EA-48N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6688YHolt Kyle · Cottontown, TNBuilt 1979 · S/N EA-47N668DESteele Kevin · Phoenix, AZBuilt 1983 · S/N EA363N6692RToga LLC · Scottsdale, AZBuilt 1980 · S/N EA-55N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N6696ZMonahans Affordable Homes LLC · Monahans, TXBuilt 1980 · S/N EA-56N669JMMerrell Bros Aviation LLC · Kokomo, INBuilt 1980 · S/N 340A0971N66CEM&S Real Estate Management Inc · Granbury, TXS/N 21061391N66DFClark Samuel D Trustee · Wilson, WYBuilt 1977 · S/N 210-621-41N66LHLane Law Firm Pc · Greenwood Village, COBuilt 1981 · S/N EA-261N66MLBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 21062598N66RAGasu LLC · Henderson, NVBuilt 1981 · S/N 340A1231N66SFRed Rock Flying School LLC · Mesa, AZBuilt 1986 · S/N 46-8608042N66TEFly4fun LLC · El Segundo, CABuilt 1978 · S/N P21000154N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363
Back to AD 89-24-01 R1