OpenAirDocs.org
AD 75-23-08 R5

Registered aircraft · 999

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:75-23-08-R5')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5')
  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.

N677HCWashburn Wall Systems LLC · Cedar Rapids, IAS/N 421B0387N678DBGolden Eagle Flight LLC · Farmington, UTBuilt 1975 · S/N 421B0876N6796VBar Wr Air Services LLC · Dallas, TXS/N 421C1045N6798VGaylord Hangars LLC · Gaylord, MIBuilt 1982 · S/N 421C1254N6798XSale Reported · WurzburgSale reported, pending cancellationS/N 421C1061N679JJClement James H Jr · Dallas, TXS/N 421C0637N67JVNext Gen Aviation LLC · Jenks, OKBuilt 1978 · S/N 421C0429N67RKRiley Matthew · Xenia, OHS/N 310Q1107N6824CK&L Salty Air LLC · Stephenville, TXBuilt 1980 · S/N 421C0865N6830LN661w Air LLC · Dalton, GABuilt 1980 · S/N 310R2102N6834CHigh Performance Aero LLC · Dover, DEBuilt 1978 · S/N 421C0476N6838XOcean Flight Corp · Weston, FLBuilt 1978 · S/N 402B1346N6858CSns Air LLC · Billings, MTBuilt 1978 · S/N 421C0481N685CPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 310R-1375N685GFAvant Homes LLC · Atlanta, GAS/N 421C0680N6865ZBarriault Ronald F · Greenville, MES/N 421C1068N6866LPoquoy Brook Aviation LLC · North Attleboro, MAS/N 421C1077N6867F81 Cessna 421 LLC · Ladson, SCS/N 421C1086N6867LRubin Broadcasting Inc · San Jose, CAS/N 421C1087N6867ZSonic Bird 1 LLC · Hagerstown, MDBuilt 1981 · S/N 421C1090N68685S&S Airplane LLC · Knoxville, TNS/N 421C1102N6869Z421 Holdings LLC · Zanesville, OHS/N 421C1111N6882MScuttle421 LLC · Sugar Land, TXS/N 421C1074N688SPSanchez Eddy B · Miami Gardens, FLS/N 402B0603N69369Mobarak Motorsports LLC · Singer Island, FLBuilt 1973 · S/N 402B0516N69571Michaels Daniel T · Mars, PABuilt 1973 · S/N 310Q0789N698DRAtm Asset Management LLC · Nashville, TNS/N 421C0235N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055N699JSJustin Seth Drach Pa · Jacksonville, FLBuilt 1975 · S/N 421B0941N69PBAerocraft Papa Bravo LLC · Hallandale, FLS/N 402B-1248N6LHTrico One-Ten Inc · Azle, TXBuilt 1972 · S/N 421B0227N6RWMagee Creek Wings & Things LLC · Rice, WABuilt 1973 · S/N 310Q0751N6SQTate Thomas E · Glendale, CABuilt 1972 · S/N 310Q0625N6WMSchrader Jerome · Rocklin, CABuilt 1974 · S/N 421B0834N700FBBocre Leasing Inc · Hauppauge, NYBuilt 1977 · S/N 421C0342N700LCRent Collector LLC · College Station, TXS/N 421C0836N701AMQuest Aviation Inc · Lake City, FLBuilt 1973 · S/N 421B0366N702NCEagle Leasing Inc · Gaylord, MIS/N 421B-0875N706AAArcher Automotive Inc · Houston, TXBuilt 1981 · S/N 421C1075N706NCGaylord Hangers LLC · Gaylord, MIBuilt 1975 · S/N 421C0037N707DMRegistration Pending · Portland, MERegistration pendingBuilt 1971 · S/N 421B0145N707DTFresco Toys LLC · Miami, FLBuilt 1973 · S/N 421B0468N707HATailwinds Aero LLC · Dubuque, IAS/N 421C1044N707SPWagon Wheel Distributing Inc · Dallas, TXBuilt 1973 · S/N 421B0411N707TPRicker David · Conway, ARS/N 421C0271N70CPOff To The Races LLC · St George, UTBuilt 1975 · S/N 421B0950N7116WEzra Aviation LLC · Katy, TXBuilt 1974 · S/N 421B0827N711KZPlp Casino Game Development LLC · Leesburg, FLBuilt 1976 · S/N 421C0023N711TPSmith Marion III · San Francisco, CABuilt 1973 · S/N 421B0454N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908
Back to AD 75-23-08 R5