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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N234MSVertical Horizon Aviation LLC · Sandown, NHBuilt 1975 · S/N 3400351 N234PSTkn Holdings LLC · Pima, AZBuilt 1977 · S/N 340A0368 N234PTJaguar Management Group LLC · Wilmington, DEBuilt 2000 · S/N EA-662 N234SBDaly Arthur P · El Paso, TXBuilt 1981 · S/N P21000673 N234SDHerndon Aviation LLC · Kokomo, INBuilt 1981 · S/N EA-200 N234TCAg N234tc LLC · South Salt Lake, UTBuilt 1974 · S/N 310R0050 N234WIwaa Inc · Woodstock, GABuilt 1976 · S/N 21061618 N235DRegistration Pending · Mead, CORegistration pendingBuilt 1978 · S/N TJ-134 N235EGHch Aircraft LLC · El Paso, TXBuilt 1985 · S/N EA-443 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N235WHTail Aero Corp · Wilmington, DEBuilt 1977 · S/N 21061797 N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805 N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116 N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43 N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020 N2375SLundin Lawrence D · Midvale, IDBuilt 1976 · S/N 21061257 N237MArdizzone Mark R · Mckinney, TXBuilt 1965 · S/N 293 N2384SChervenak A Douglas · Smyrna, DEBuilt 1976 · S/N 21061263 N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808 N23FGState Of California Dept Of Fish & Game · Sacramento, CABuilt 1980 · S/N 18504035 N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509 N23HBHotel Bravo Aviation LLC · Houston, TXBuilt 1977 · S/N 21062050 N23KBRegistered aircraftBuilt 1985 · S/N P21000845 N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258 N23SJRatnikov Dmitry · Jay, NYBuilt 1981 · S/N EA-222 N240HCBlodgett James R · Walnut Creek, CABuilt 1979 · S/N TJ-221 N240SQMigster LLC · Miami, FLBuilt 1975 · S/N 310R0273 N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78 N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136 N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012 N2423SAircraft Sales LLC · Caledonia, MIBuilt 1976 · S/N 21061275 N2425SPark Sung S · Marana, AZBuilt 1976 · S/N 21061276 N242GDodson International Parts Inc · Rantoul, KSS/N 340A0799 N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049 N242KABig River Air LLC · Jackson, MSBuilt 1983 · S/N 340A1802 N242RYCity Management Corp · Sunriver, ORBuilt 1978 · S/N P21000036 N2437UPlanetosea LLC · Doylestown, PABuilt 1983 · S/N 21064782 N2441SSzpara John V Trustee · Chesnee, SCBuilt 1976 · S/N 21061284 N2453SFilipponi-Thompson Drilling Inc · Atascadero, CABuilt 1976 · S/N 21061294 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355 N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253 N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N247MFsvc Aero Inc · Wilmington, DES/N 288 N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678 N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249 N24CFAmerica Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0659

Back to AD 89-24-01 R1