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.

N1942XGarrison Weldon · Texarkana, TXBuilt 1979 · S/N P21000296N1944EHans Construction LLC · Lititz, PAS/N 340A0675N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306N1961UMccarthy Trevor William · Addison, TXBuilt 1974 · S/N U20602312N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298N1995GHarris Justin R · Hico, TXBuilt 1974 · S/N 414-0602N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N199RPId Corporation · Shepherd, MTS/N EA-344N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N1FHBuermann Henry · Brookfield, VTS/N 18052817N1KPSherman Loren R Jr · Granbury, TXBuilt 1973 · S/N 21060006N2002PGregory Edward · Council Bluffs, IABuilt 1979 · S/N 335-0022N200GCDancy Abram P · Shrewsbury, MABuilt 1978 · S/N 340A0503N200MCN200mc Inc Trustee · Cheyenne, WYBuilt 1973 · S/N 414-0424N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073N200RTRiley Nolan C · Lubbock, TXS/N TK-101N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979N2012S9791m LLC · Tacoma, WAS/N 21060980N2018LKrielow Law Firm LLC · Thibodaux, LABuilt 1978 · S/N TK-80N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987N201DRegistered aircraftS/N TK-24N2028SScherler Burl M · Sheridan Lake, COBuilt 1975 · S/N 21060996N202SWMar Jar LLC · Gilmer, TXBuilt 1980 · S/N 414A0515N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165N2034JMd Aero LLC · Somerton, AZBuilt 1978 · S/N T18803339TN2037ACrosswind Enterprises LLC · Box Elder, SDBuilt 1979 · S/N EA-3N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010N2046SYankee Clipper LLC · Dayton, OHS/N 21061013N2050SDavis Bryan C · Winfield, KSBuilt 1975 · S/N 21061017N2055QJones Jeff A · Lewiston, IDBuilt 1975 · S/N U20602965N2056NN2056n LLC · Wilmington, DEBuilt 1978 · S/N TJ-156N2056SAcevedo Adriel · San Antonio, TXBuilt 1975 · S/N 21061023N2058CScorpion Aviation LLC · Hemet, CABuilt 1978 · S/N TK-85N2059PNiemi Aviation LLC · Glyndon, MNBuilt 1998 · S/N TJ-159N205CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0207N20602Bromschwig Kurt F Trustee · Montgomery, TXS/N TJ-173N2061KMile High Air Inc · Canyon, TXBuilt 1978 · S/N TJ-161N2063JWest Aviation Inc · Creston, IABuilt 1978 · S/N T18803353T
Back to AD 89-24-01 R1