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.

N512SBN512sb LLC · Austin, TXBuilt 1981 · S/N P21000762N512SLSalmon Raymond A Trustee · Tavares, FLBuilt 1984 · S/N TJ-472N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852N5134WPlane Fun Inc Tr Trustee · Snellville, GAS/N P21000643N513DWright Aero Inc · Saint Cloud, MNBuilt 1976 · S/N 340A0048N5140JTruk Err Inc · Wilmington, DEBuilt 1975 · S/N 340-0530N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851N514HRSethi Inderdeep Singh · Tracy, CABuilt 1980 · S/N EA-70N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514N5151JHalverson Mechanical Inc · Ogden, UTBuilt 1975 · S/N 340-0541N5151QNotsa LLC · Morrison, COBuilt 1972 · S/N 21059651N5154AA&J Air Sales Inc · San Antonio, TXS/N 21063289N5156QN5156q Inc · Elmhurst, ILFirst renewal noticeBuilt 1972 · S/N 21059656N5156YCaprock Spraying Inc · Vega, TXBuilt 1980 · S/N 21064100N5159ADavis Nicholas R · Madera, CABuilt 1979 · S/N 21063292N515DCmmk LLC · Talent, ORBuilt 1980 · S/N 340A-1022N515FVSlowmow Inc · Palestine, TXS/N 414-0410N515RJFroehlich Franz M · Oceanside, CABuilt 1983 · S/N EA-357N515RRHangar 49 Ltd · Wilmington, DEBuilt 1987 · S/N 4608080N515RTCemco Industrial Park LLC · Belen, NMBuilt 1976 · S/N 21061235N515STQ&A Holdings LLC · Elkridge, MDBuilt 1971 · S/N 414-0169N5160JZemnickas William V · Metamora, MIS/N 340-0550N5163JQuantie Harold · Locust Grove, OKBuilt 1975 · S/N 340-0553N5165JPeak Wings LLC · Missoula, MTBuilt 1975 · S/N 340-0555N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5169JPotter Kent W · Laurel, MTBuilt 1976 · S/N 340A0004N5175JAycock Charles C · Midland, TXS/N 340A0010N5177MElh Aviation LLC · Flint, MIBuilt 1977 · S/N TJ-116N5178JSeven Eight Juliet LLC · Edmond, OKS/N 340A0013N5181JForce One Inc · Missoula, MTBuilt 1975 · S/N 340A0016N5182JEmery & Associates Inc · Orangeville, PAFirst renewal noticeS/N 340A0017N5183WG S I Training Services Inc · Branson, MOBuilt 1981 · S/N P21000650N5189ABarrymore Cole · Government Camp, ORBuilt 1979 · S/N 21063302N5189YKmc Aviators LLC · Burlington, CTBuilt 1980 · S/N 21064114N518PCJnc Holdings LLC · Mequon, WIBuilt 1977 · S/N 340A0433N5191VTrue Drilling LLC · Casper, WYBuilt 1975 · S/N 21060857N5195AOlson Brothers · Williams, AZBuilt 1979 · S/N 21063304N519SCCrockett Ryan · Veradale, WAFirst renewal noticeBuilt 1979 · S/N 340A0720N51APConrad Alan B · Las Vegas, NVBuilt 1980 · S/N 340A0970N51BWMcclymond Bruce W · Breckenridge, TXBuilt 1981 · S/N 21064602N51CXAerodata LLC · Ann Arbor, MIBuilt 1978 · S/N 340A0533N5201ADan Howard Aircraft Sales LLC · Tulsa, OKBuilt 1979 · S/N 21063305N5203AGv Air Inc · Medford, ORBuilt 1979 · S/N 21063306N5203XMike & Critter LLC · Mccall, IDBuilt 1980 · S/N U20605592
Back to AD 89-24-01 R1