AD 75-20-03

Registered aircraft · 735

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

N1390TAccessible Aviation Inc · Tupelo, MSBuilt 1972 · S/N 34-7250274N1397HIngold Terry L · Albemarle, NCS/N 34-7770124N13AGWeather Modification LLC · Fargo, NDBuilt 1977 · S/N 34-7770115N13LMTupelo Limited Lc · Lake Charles, LAFirst renewal noticeS/N 34-7870075N1407TAndrews University · Berrien Springs, MIBuilt 1972 · S/N 34-7250311N1411XMaarouf Dan H · Seabrook, TXBuilt 1975 · S/N 34-7570239N1416XTop Tier Truck And Trailer LLC · Dimmitt, TXBuilt 1975 · S/N 34-7570241N1421TBurr Charles R Jr · Palm Bay, FLBuilt 1972 · S/N 34-7250314N14258Bayshore Aviation LLC · Saint Petersburg, FLS/N 34-7350180N142GDDeaero LLC · Darwin, MNBuilt 1980 · S/N 34-8070314N1436TDeland Aviation LLC · Deland, FLBuilt 1972 · S/N 34-7250317N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252N147BZSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 34-7870359N148PFMacallen Chemical Inc · Monroe, LABuilt 1978 · S/N 34-7970017N14FPBakowicz John R · Sunbury, PABuilt 1974 · S/N 34-7450096N14FZWurzer Frank · Tallmadge, OHBuilt 1978 · S/N 34-7870122N14JNNational Test Pilot School · Mojave, CABuilt 1975 · S/N 34-7570254N14SSBas Part Sales LLC · Greeley, COS/N 34-7770385N15008Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250346N15018N15018 LLC · Sanger, TXBuilt 1972 · S/N 34-7250347N15024Whytes Inc · Coconut Creek, FLBuilt 1972 · S/N 34-7250349N15035Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250353N15064Kropp Christian Owner Trustee · Azle, TXS/N 34-7350005N15089Tusla Technology Center School District #18 · Tulsa, OKS/N 34-7350018N15145Tri-Star Aviation Inc · La Porte, TXBuilt 1972 · S/N 34-7350026N1519THigh Flyers Aviation Services LLC · Gaithersburg, MDBuilt 1972 · S/N 34-7250337N15215Curtis David W · Watertown, NYBuilt 1972 · S/N 34-7350036N1532XRaymond Darwin V · Glenwood Springs, COBuilt 1975 · S/N 34-7570275N1533EPhoenix East Aviation LLC · Daytona Beach, FLS/N 34-7350050N1536XClark Christopher · Ormond Beach, FLBuilt 1975 · S/N 34-7570276N1551XLeverson Christopher · Austin, TXFirst renewal noticeBuilt 1975 · S/N 34-7570283N15529Pattie Donald D · Zephyrhills, FLBuilt 1972 · S/N 34-7350072N1555XShelton Brad · Wildwood, MOBuilt 1975 · S/N 34-7570284N15589Neal Alan B · Cherry Valley, CABuilt 1972 · S/N 34-7350078N15647Flynn Daniel C · Malvern, PAS/N 34-7350082N15709Avioelectronica Inc · Sunrise, FLS/N 34-7350088N1570XTmstarservices LLC · Lewes, DEBuilt 1975 · S/N 34-7570290N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094N157BJHolm Brian · Buckley, WABuilt 1975 · S/N 34-7570282N15839Phoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350100N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109N16292Morcom Aviation Services Inc DBA · Everett, WABuilt 1973 · S/N 34-7350125N162BWSimply Living LLC · Fort Myers, FLBuilt 1975 · S/N 34-7570147N170TBIal Corp · Lewes, DEBuilt 1973 · S/N 34-7350190N181FMLuse Otis · Lago Vista, TXS/N 34-7770400N1839HFly 172n LLC · Peoria, AZBuilt 1977 · S/N 34-7770152N1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 34-7770153N189MLStrobe Aviation LLC · Columbia, SCBuilt 1977 · S/N 34-7770114N18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeBuilt 1979 · S/N 34-7970151
Back to AD 75-20-03