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.

N3465GGv Air Inc · Medford, ORS/N 310R0844N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N34ADPremiere Aviation Inc · Concord, CABuilt 1975 · S/N 421C-0036N34AGJ D Aviation Leasing LLC · Mundelein, ILS/N 421C0901N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597N3517GGv Air Inc · Medford, ORS/N 310R0860N3540MDybel William P · Frankfort, ILS/N 421B0472N355RTBeechwood Aviation LLC · Wilmington, DEBuilt 1974 · S/N 421B0633N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795N3587GAtor Robert W · Beach City, TXS/N 310R0874N358MNKeystone Aerial Surveys Inc · Philadelphia, PAS/N 310R0881N35FSSelistli LLC · San Mateo, CABuilt 1974 · S/N 421B0831N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N364NYMarc Inc · Bolton, MSS/N 310R-0718N365FDci Air LLC · Dodge City, KSBuilt 1980 · S/N 421C0854N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071N371SBN333bc LLC · Franktown, COS/N 421C1072N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339N37417Registered aircraftS/N 421C0344N37424Flight Development LLC · Wichita, KSS/N 421C0658N37475N37475 Management LLC · Las Vegas, NVBuilt 1977 · S/N 421C0412N37478Ghareeb Enterprises Inc · Charleston, WVS/N 421C0415N375KCGuittard Chocolate Holdings Co · Burlingame, CABuilt 1982 · S/N 421C1226N37676Campbell & Associates Investment Properties LLC · Burleson, TXBuilt 1974 · S/N 421B0584N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221N378KAga Aviation LLC · Lewes, DES/N 421C0499N3796CPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1974 · S/N 402B0803N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914N37JKSsr LLC · Incline Village, NVS/N 421B0934N37MBresciani Martin · Guaynabo, PRS/N 421B0805N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711N382MCShiver James B · Stanley, NMS/N 421B0452N384AMHaggard Haley G · Springer, OKS/N 421B0304N3908CMccreery Aviation Co Inc · Mcallen, TXBuilt 1976 · S/N 421C0136N3920CN3920c Lc · Wichita, KSBuilt 1976 · S/N 421C0145N3922CN3922c LLC · Dover, DEBuilt 1977 · S/N 421C0419N3923CSwope Aviation LLC · Elizabethtown, KYBuilt 1976 · S/N 421C0147N393MPDutch Indian Air LLC · Riverdale, CABuilt 1976 · S/N 421C0203N3968GWatkins Aviation LLC · Golden Valley, MNBuilt 1977 · S/N 421C0422N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N39WHGolden Touch LLC · Kalispell, MTBuilt 1976 · S/N 421C0070N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N400BJAirrich LLC · Largo, FLBuilt 1974 · S/N 421B0819
Back to AD 75-23-08 R5