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.

N421TVYuba City Solar Millennium Fund LLC · Rocklin, CABuilt 1982 · S/N 421C1253N421TXHolly Factory · Alachua, FLBuilt 1985 · S/N 421C1807N421UTR&C Welding And Fabrication Inc · Gering, NES/N 421C1107N421VHead Rest Ltd LLC · Las Vegas, NVBuilt 1977 · S/N 421C0449N421VAMagafly LLC · Bay City, MIBuilt 1977 · S/N 421C0219N421VCEr Aviation LLC · Brazil, INS/N 421B0428N421VFN421vf LLC · Lindsay, TXBuilt 1976 · S/N 421C0093N421VGCooper421 LLC · Haltom City, TXBuilt 1982 · S/N 421C1240N421VJH C LLC · Ponca City, OKBuilt 1978 · S/N 421C0507N421VR421vr LLC · Denver, COS/N 421C0700N421VVTower Aviation Management LLC · Wilmington, DEBuilt 1975 · S/N 421B0959N421WBBas Part Sales LLC · Greeley, COS/N 421C1213N421WCOne Eyed Pilot LLC · Columbia, SCBuilt 1977 · S/N 421C0278N421WDKilo Aviation LLC · East Peoria, ILBuilt 1973 · S/N 421B0469N421WEInternational Air Services Inc Trustee · Carson City, NVS/N 421C0024N421WKKb Air LLC · Bakersfield, CABuilt 1981 · S/N 421C1230N421WNContractors Flight Service LLC · La Jolla, CABuilt 1976 · S/N 421C0100N421WPMach 1 LLC · Rogers, ARS/N 421C0417N421WSGandy John B · Conroe, TXBuilt 1977 · S/N 421C0433N421WTWest One Holdings Inc · Cheyenne, WYBuilt 1978 · S/N 421C0620N421WXCeaco Inc · Las Vegas, NVS/N 421B0262N421XLLocaero Services Inc Trustee · Wilmington, DEBuilt 1979 · S/N 421C0803N421XTAdam & Anya Holdings LLC · Wichita, KSBuilt 1978 · S/N 421C0447N421XXLong William David · San Antonio, TXBuilt 1976 · S/N 421C0238N421YBBotsis Aircraft Limited Inc · Chesterland, OHS/N 421C1212N421YPWateractive43 LLC · Auburn, CAS/N 421B0511N421YWTrl Aviation LLC · Little Rock, ARBuilt 1984 · S/N 421C1402N421YYVsa Leasing LLC · Linden, MIBuilt 1980 · S/N 421C0872N421ZM3tr Aviation LLC · Longview, TXBuilt 1981 · S/N 421C1058N421ZXBurmingham Don Trustee · Duarte, CAS/N 421C0304N421ZZ421zz LLC · Wilmington, DES/N 421C1220N422CMAerostar Aviation LLC · Tucson, AZBuilt 1981 · S/N 421C1046N422DBurton Rick · Vancouver, WABuilt 1982 · S/N 421C1202N422GMMidocin LLC · Southfield, MIBuilt 1976 · S/N 421C0055N422PJCra Aviation LLC · Dickerson, MDBuilt 1981 · S/N 421C-1038N423TMJp Aviation Leasing LLC · Salt Lake City, UTBuilt 1976 · S/N 421C-0107N424JAJzj Air LLC · Wilmer, ALS/N 421C0885N4251TJett Shelby Kerman · Pewee Valley, KYS/N 421B0533N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394N427CCBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 1977 · S/N 421C0348N427JMPittman James L · Destin, FLS/N 421C0103N429GMResendiz Marcelino · Alamo, TXBuilt 1982 · S/N 421C1251N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342N42HMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N 421C0683N42MLRegistered aircraftS/N 421C0639N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224
Back to AD 75-23-08 R5