OpenAirDocs.org
AD 75-16-20

Registered aircraft · 63

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-16-20')
    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-16-20')
  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.

N100CFRed Rooster Rentals LLC · Alto, GABuilt 1972 · S/N 229N100KEPm Leasing Inc · Perris, CABuilt 1974 · S/N 313SAN11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285N122MAPanda Aviation Inc · Washougal, WAS/N 207N129DWDelta Whiskey Ltd · Staten Island, NYBuilt 1974 · S/N 653N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324N15TCStax Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 692N165MARegistered aircraftBuilt 1975 · S/N 326N18BFCenter For Endodontics Inc · Fresno, CABuilt 1969 · S/N 173N2100TJ R Aero Leasing Inc · Lawrence, KSBuilt 1969 · S/N 182N216CDLandry Camile J · Baton Rouge, LABuilt 1974 · S/N 323N228WPRegistration Pending · Wichita, KSRegistration pendingBuilt 1972 · S/N 228N22MZChurchill Robert Jr · Wasilla, AKS/N 158N261WBNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1975 · S/N 330N272MCN272mc Leasing LLC · South Jordan, UTBuilt 1973 · S/N 272N281MAWife Approved LLC · Torrance, CABuilt 1973 · S/N 261N28AFEumundi Trading Co Inc · Wilmington, DES/N 241N305DSAircraft Operations LLC · Portland, ORBuilt 1975 · S/N 328N316ENFayetteville Aviation Inc · Fayetteville, TNBuilt 1976 · S/N 349SAN324GMSycan Corp DBA · Paso Robles, CABuilt 1974 · S/N 310N325MASouthern Aviation LLC · Durham, NCBuilt 1974 · S/N 325N375ACCelco Constantine Eng Lab Co · Wilmington, DEBuilt 1975 · S/N 327N383TXPositive Rate LLC · Eatonton, GABuilt 1975 · S/N 332N3GTR&G Aircraft LLC · Zeeland, MIS/N 277N40KCAir 1st Aviation Companies Inc · Glendale, AZBuilt 1974 · S/N 322N450FSRaju Leasing Co LLC · Jackson, MSBuilt 1976 · S/N 338N461MAGood Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 301N462MARegistered aircraftBuilt 1974 · S/N 302N480AFAir 1st Aviation Companies Inc · Aiken, SCS/N 248N481AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 253N482AFAir 1st Aviation Companies Inc · Tyndall Afb, FLS/N 265N483AFAir 1st Aviation Companies Inc · Aiken, SCBuilt 1973 · S/N 271N485AFLaver Michael · Glendale, AZBuilt 1974 · S/N 308N486AFAir 1st Inc · Tyndall Afb, FLBuilt 1975 · S/N 329N487AFAir 1st Aviation Companies Inc · Tyndall Afb, FLBuilt 1975 · S/N 333N489AFLaver Michael · Glendale, AZS/N 243N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668N507ZZAce Aviation LLC · Mankato, MNS/N 264N50AFWyoming Aeroflight LLC · Laramie, WYS/N 286N50ETRegistered aircraftBuilt 1973 · S/N 260N50KSedghi Reza · Macon, GABuilt 1974 · S/N 305N54CKNewton Property Leasing LLC · Greene, IABuilt 1968 · S/N 135N54PCAxel Neil Jeffery · Portland, ORBuilt 1974 · S/N 319N59KSOconnell Meares Investments Ltd · Tampa, FLBuilt 1974 · S/N 664N601SDJefferson County Sheriffs Office · Beaumont, TXBuilt 1973 · S/N 610N616KLFraser Peter · Powell Butte, ORBuilt 1973 · S/N 267N621TAAustin Bill DBA · Sparta, TNS/N 605N64LGRed Star Aero Services LLC · Mobile, ALBuilt 1972 · S/N 240N687HBSouthern Jets Inc · Naples, FLS/N 687
Back to AD 75-16-20