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.

N268JBIn Tune Entertainment Inc · Scottsdale, AZBuilt 1980 · S/N 421C0866N269CGold Beach Lumber Yard Inc · Brookings, ORS/N 421C0170N26GDGragert Richard Trustee · Katy, TXBuilt 1978 · S/N 421C0448N26HEMccreery Aviation Co Inc · Mcallen, TXBuilt 1979 · S/N 421C0687N26LFForte Paul · West Bloomfield, MIS/N 421C0710N274MBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 421C0315N27KCLaperle Brian · Colebrook, NHBuilt 1974 · S/N 310Q1134N28409Gilmore Sherry · Sallisaw, OKS/N 310Q0666N284DMDreamworks Aviation LLC · Palm Beach Gardens, FLBuilt 1984 · S/N 421C1406N28835Waddingham William B · Rancho Cucamonga, CABuilt 1969 · S/N 421A-0050N28849Roonie Inc · Wilmington, DES/N 310Q0036N28RHNational Airplane Sales & Leasing Corp · Lima, OHBuilt 1980 · S/N 421C0847N28WDOptio Air LLC · Moore, OKS/N 421C0715N291ANKb Flies LLC · Amarillo, TXS/N 421C0242N2957QGenerals International Inc · Red Oak, TXBuilt 1969 · S/N 421A0057N299GBHoodoo LLC · Missoula, MTBuilt 1980 · S/N 421C1031N29XXMustang Aeronautics LLC · Chandler, AZBuilt 1975 · S/N 421C0035N2JAJadair International Inc · Port Washington, WIBuilt 1976 · S/N 421C0154N2LYMagnolia Air LLC · Starkville, MSS/N 421C0301N300BDAircraft Inc · White Bear Lake, MNBuilt 1975 · S/N 310R0258N300BRMach Tuck Aero Group LLC · Elkhorn, NES/N 421C0453N300FDGondola Investments LLC · Miami, FLS/N 402B1359N300MBIglesia De Cristo · Porter Ranch, CABuilt 1974 · S/N 421B0573N302MCB & G Ventures LLC · Kalispell, MTBuilt 1973 · S/N 310Q0909N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N304MCValiair Lc Trustee · Casper, WYS/N 421B0130N307FMNorris Aviation LLC · Mansfield, TXBuilt 1977 · S/N 421C-0323N308CFBaba Kenneth D · Sierra Vista, AZBuilt 1973 · S/N 310Q0804N30ETZaldivar Carlos · Miami, FLBuilt 1971 · S/N 310Q0266N30LTJuans Adios LLC · Newark, DES/N 421C0290N30PTGas Aviation LLC · Decatur, TNBuilt 1976 · S/N 421C0157N310ADChang Stephen · Santa Barbara, CABuilt 1976 · S/N 310R0538N310AMCwr Enterprises Inc · Henderson, NCBuilt 1979 · S/N 310R1672N310BARampey Alvin H Jr · Atlanta, GABuilt 1975 · S/N 310R0065N310BFGv Air Inc · Medford, ORBuilt 1978 · S/N 310R1390N310BLAlsager Joshua D · Kindred, NDS/N 310Q0069N310CESwainston Ian · Las Vegas, NVBuilt 1974 · S/N 310Q1063N310DChispa Air LLC · Cedar Park, TXBuilt 1969 · S/N 310Q0002N310DHFavero Robert B · Weed, CABuilt 1974 · S/N 310Q1086N310EWAerial Imaging Inc · South Bend, INBuilt 1973 · S/N 310Q0935N310FJSimmonds Don M · Sandpoint, IDS/N 310Q0542N310GCCook Kevin M · Missouri City, TXBuilt 1973 · S/N 310Q0838N310HBSmith William G · Huntsville, TXBuilt 1980 · S/N 310R1876N310HDWwdd Enterprises LLC · Port Orange, FLBuilt 1975 · S/N 310R0519N310HMInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 310R1282N310JABruner Matthew · Scottsbluff, NEBuilt 1978 · S/N 310R-1319N310JGMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1567N310JNAustin Baumgarten Inc · Tomah, WIBuilt 1977 · S/N 310R0979N310JPBrock Kyle · Riverdale, CABuilt 1972 · S/N 310Q0648N310JWWharton Melissa P · Wise, VABuilt 1977 · S/N 310R0956
Back to AD 75-23-08 R5