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

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.

N69PBAerocraft Papa Bravo LLC · Hallandale, FLS/N 402B-1248 N69PGBaird Mark · Fort Jones, CABuilt 1972 · S/N 340-0062 N69WAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1982 · S/N 21064707 N6ED3 Rivers Inc · St George, UTS/N TJ-9 N6HGBagwell Harold G · Garner, NCBuilt 1978 · S/N 21062624 N6MKSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 340-0322 N6NTNevada Defense Group LLC · Henderson, NVBuilt 1978 · S/N P21000109 N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751 N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625 N7000KCohen Phillip A · Hopkinton, MABuilt 1978 · S/N 210-62553 N700DKFlysix Oregon LLC · Salem, ORBuilt 1980 · S/N 340A1038 N700HBLucky7 Air LLC · Lenoir, NCBuilt 1982 · S/N 414A0810 N700RSTransavia LLC · Wilmington, DEBuilt 1981 · S/N P21000716 N700VRMountain & Vine LLC · Park City, UTBuilt 1979 · S/N TJ-194 N701CJCenturion Aviation Ltd · Salina, KSBuilt 1968 · S/N 401A0022 N701MDDel Mar Aviation LLC · Algona, IABuilt 1980 · S/N 21064007 N701PSLucky US LLC · Merrill, WIBuilt 1977 · S/N 21062339 N7022GSamarth Aviation LLC · Yuma, AZBuilt 1979 · S/N 340A0695 N702DDJoyce Consulting LLC · Black Hawk, SDBuilt 1999 · S/N EA-644 N702TCSykes Gregory P · Arlington, WAFirst renewal noticeBuilt 1976 · S/N 21061672 N7037EHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0471 N70570Miel Del Rio Grande Inc · Monte Vista, COBuilt 1973 · S/N U20602083 N70595Lung Aerial Group Inc · Tustin, CABuilt 1973 · S/N U20602085 N706CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0095 N707BWDrago Air LLC · Mulberry, INBuilt 1984 · S/N 340A1812 N707LJFront Row LLC · Los Alamos, NMBuilt 1979 · S/N EA-4 N707MPEmmet Street Holdings LLC · Saint Petersburg, FLBuilt 1978 · S/N TJ-166 N707RLApplegate Properties LLC · Morris, ILS/N T303-00008 N70SLMcleod Sammy Dale Jr · Spring, TXBuilt 1986 · S/N EA-459 N710FSCaddis Flyers LLC · Kalispell, MTS/N 340-0355 N710TDDuke Ray J · Oak Point, TXBuilt 1976 · S/N 21061424 N711BGSaybrook Offshore LLC · Guilford, CTBuilt 1982 · S/N P21000806 N711CBRoundhive Corp · New York, NYBuilt 1979 · S/N 340A0913 N711HEDesert West Enterpises LLC · Roswell, NMBuilt 1979 · S/N P21000242 N711PJRender Chad · Pine Bluff, ARS/N 21061128 N711SDMundy William L · Proctorville, OHS/N 340A0958 N711TWMartens Ruth C · Wheaton, ILBuilt 1978 · S/N 21062654 N711YLBurkett Gary L Trustee · Murfreesboro, TNBuilt 1979 · S/N 340A0955 N712GLThere And Back LLC · Tulsa, OKBuilt 1975 · S/N 340A0029 N712LSDwyer Stephen C · The Woodlands, TXBuilt 1979 · S/N TJ-192 N712SBSinger Nathan · Pismo Beach, CABuilt 1975 · S/N 310R0122 N713TGSelway Construction Group LLC · Moscow, IDBuilt 1979 · S/N U20605218 N714DBIpiranga Inc · Houston, TXBuilt 1996 · S/N EA-585 N717BDWeathered Aviation Inc · Rogers, ARBuilt 1979 · S/N 414A0337 N717BLWeaver Air LLC · Starkville, MSS/N 46-8508082 N717CGContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N 414-0495 N717DKRegistration Pending · North Las Vegas, NVRegistration pendingBuilt 1973 · S/N 21060113 N717MRSt Johns Aviation Partners II · Beaumont, TXBuilt 1980 · S/N P21000601 N717TVPinkert Sy · Silverthorne, COBuilt 1978 · S/N 310R1341 N71MKWyeth Patrick · Chino Valley, AZBuilt 1980 · S/N P21000590

Back to AD 89-24-01 R1