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.

N771CMCollvins Robby D · Mount Vernon, TXS/N 310R0934N777TSEmery Edward F DBA · Bloomsburg, PAS/N 421B0352N777VMiso Enteprises LLC · Wilmington, DES/N 310R0267N77EPCba Air LLC · Tuscaloosa, ALBuilt 1973 · S/N 421B0478N780JCN780jc Inc · Orlando, FLBuilt 1974 · S/N 421B0582N780MBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 402B-0249N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432N788JJGreenlee Joseph A III · Fort Wayne, INBuilt 1975 · S/N 421B0851N789BDTroy Farms Lp · Delano, CABuilt 1973 · S/N 310Q0922N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620N790XPrecision Design Inc · Weatherford, OKS/N 421A0087N799TFGallien Anthony · Livermore, CAS/N 421B0324N79JFFour Twenty One LLC · Kalispell, MTBuilt 1977 · S/N 421C0340N79TDFlying Bs LLC · Canby, ORBuilt 1972 · S/N 421B0325N7ZZFour Clowns Aviation LLC · Wilmington, DEBuilt 1968 · S/N 310P0049N800KWVenture Air Solutions Inc · Opa Locka, FLBuilt 1976 · S/N 402B1063N800SMTofanzadeh Abdolreza · Chula Vista, CABuilt 1972 · S/N 421B-0275N8047QAir Boys Inc · Hayward, WIBuilt 1970 · S/N 421B0047N808BVFlying Dutchman LLC · Waipahu, HIBuilt 1975 · S/N 421C0004N8091QKhag Aviation Inc · Woodbridge, NJBuilt 1973 · S/N 402B0369N8093QRobey Sean C · Camden, NCBuilt 1973 · S/N 421B0544N80LGTru North Aviation LLC · Ironwood, MIBuilt 1975 · S/N 421C0021N80RSRoberson Mark E · Milton, FLBuilt 1975 · S/N 421B0895N811NATm Aero LLC · Riverview, FLS/N 421C-1082N811PGH&S Aircraft LLC · Lewes, DEBuilt 1984 · S/N 421C1413N8155ASkylane Ventures LLC · Keizer, ORS/N 310R0025N816GHSteim Joseph M · Shirley, MABuilt 1978 · S/N 310R1507N816LHL Howard Construction Inc · Abernathy, TXS/N 421B0565N8179QCruce Aircraft Services LLC · Clewiston, FLBuilt 1972 · S/N 310Q0635N817GCMountain View Aeromotive Inc · Del Norte, COBuilt 1975 · S/N 310R0264N817LLJg Aero LLC · Clermont, FLS/N 421C0230N8181GAirplane LLC · Coeur D Alene, IDS/N 421C0302N8188QI Will Rise LLC · Chattanooga, TNBuilt 1972 · S/N 310Q0638N818AKWhirley Robert G · Santa Rosa, CABuilt 1981 · S/N 421C1085N818DHCouch Fred · Fort Worth, TXS/N 421C0840N818TKInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 421C0873N818XJays Aircraft Maintenance Inc · Costa Mesa, CAS/N 421C1021N819RARonald Jinsky LLC · Beloit, WIBuilt 1978 · S/N 421C0522N81LPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1981 · S/N 421C-1083N81RDPapaco LLC · Green Cove Springs, FLS/N 421C0291N821KAKa Consulting LLC · San Juan, PRBuilt 1981 · S/N 421C1203N821TTHome By Dark LLC · Fredericksburg, TXBuilt 1976 · S/N 421C0041N822BKPropilot LLC · San Juan, PRS/N 421C0822N826CMKuriel Michael · Las Vegas, NVS/N 421C0508N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310N83GHTebow William · Bunkie, LABuilt 1978 · S/N 310R1285
Back to AD 75-23-08 R5