OpenAirDocs.org
AD 97-05-03 R1

Registered aircraft · 2,860

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:97-05-03-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:97-05-03-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.

N3725NIvy James H III · Seligman, AZS/N D-934N3731NBerka George · Waterbury, CTBuilt 1947 · S/N D-940N3733NHorning Richard H · Galion, OHBuilt 1947 · S/N D-943N3738NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-948N373AFSe Aero II LLC · Atoka, OKBuilt 1999 · S/N 525-0308N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259N3740NCrimmins Christopher E · Franklin, TNBuilt 1947 · S/N D-956N3741NBruzzone Daniel E · Rllng Hls Est, CABuilt 1947 · S/N D-959N3742NAsp Kenneth J · Thief River Falls, MNBuilt 1947 · S/N D-960N3745NFlivver Classic Aviation LLC · Tipp City, OHBuilt 1947 · S/N D-963N3746NColvin Clu D · Big Cabin, OKS/N D-964N3754NColyer Gregory W · San Rafael, CABuilt 1947 · S/N D-973N3756NLloyd John M · West Allis, WIBuilt 1947 · S/N D-976N3758NMeyer Jeremy L · Conway Springs, KSS/N D-978N375PFConch Air LLC · Green Bay, WIBuilt 2001 · S/N 258558N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565N376DBae Systems Tss Inc · Mojave, CABuilt 1981 · S/N 465-76N376RARocket Air LLC · Broomfield, COBuilt 2001 · S/N 550-0995N3777NBonanza Parts Inc · Davis, CABuilt 1947 · S/N D-999N3778NOliphant Jack · Fort Collins, COBuilt 1947 · S/N D-1000N377PGJackalope Air LLC · Afton, WYBuilt 2022 · S/N 525-1133N3781NOkeefe John Thomas · Winthrop, WABuilt 1947 · S/N D-1003N3787NAircraft Partner Holdings Inc Trustee · BerlinBuilt 1947 · S/N D-1010N378DNational Test Pilot School · Mojave, CABuilt 1975 · S/N 306-101N3791NLabs Kevin A · Citrus Heights, CABuilt 1947 · S/N D-1014N3798NAviation Business Corp · Saint Louis, MOBuilt 1947 · S/N D-1160N379ECRebus II LLC · Owasso, OKBuilt 2003 · S/N 560-0642N37ETJh Aviation LLC · Rainier, ORBuilt 1999 · S/N 550-0879N37MHBeech Construction Inc · Pittsburgh, PABuilt 1980 · S/N 550-0153N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309N3807NTanner Byron D · Saint Amant, LABuilt 1947 · S/N D-1035N380CFBarkley Air LLC · Scottsboro, ALBuilt 1996 · S/N 560-0380N380CJSkyview LLC · Wilmington, DES/N 380N3814NChapman Stuart M · Vernon, COBuilt 1947 · S/N D-1043N3815NEllett Tommy A · Ferriday, LABuilt 1947 · S/N D-1044N3818NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1947 · S/N D-1047N3822NLohmann Heinrich F · Saint Louis, MOBuilt 1947 · S/N D-1054N3825NMorrison Benjamin F · Godley, TXBuilt 1947 · S/N D-1062N3826NWahl Christopher S · Jerseyville, ILS/N D-1063N3829NCostello John J Jr · Carlsbad, CABuilt 1947 · S/N D-1066N382TCSkylink Jets Inc · Fort Lauderdale, FLS/N 039N3831NTilghman Charles R Jr · Van Alstyne, TXBuilt 1947 · S/N D-1068N3835NHaraway David D · Tulsa, OKBuilt 1947 · S/N D-1072N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322N383MVSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258403N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700N3843NShafer John P · Bridgeport, OHS/N D-1081N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339N384CFMed Air LLC · Wilmington, DEBuilt 1981 · S/N 384N3850NHayden Robert P · West Fargo, NDBuilt 1947 · S/N D-1088
Back to AD 97-05-03 R1