AD 75-01-07

Registered aircraft · 2,118

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-01-07')
    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-01-07')
  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.

N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503N185THsr Creative LLC · Indian Trail, NCS/N D-9672N1860WWhittaker Gary · Southport, NCBuilt 1973 · S/N D-9500N186QExecutive Bonanza Group · Sacramento, CABuilt 1964 · S/N D-7644N1873LJanzen Mark · Chico, CABuilt 1976 · S/N D-9892N18760Twinfin LLC · Port Orange, FLBuilt 1977 · S/N D-10070N1880LSouth Regional Aviation Enterprise · Boynton Beach, FLBuilt 1976 · S/N D-9894N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313N18998Duffer Management LLC · Carlsbad, CABuilt 1977 · S/N D-10073N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125N1903LN1903l LLC · Jacksonville, FLBuilt 1976 · S/N D-9900N1909LEddies Airplanes LLC · Kalispell, MTBuilt 1976 · S/N D-9901N190QMcgilvray Saxon · Helena, MTBuilt 1964 · S/N D-7551N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172N1947MMoeny James A · Cottonwood, AZBuilt 1964 · S/N D-7547N194NASharrit Edgar W · Sebring, FLS/N D-8409N1965SN1965s LLC · Williamstown, NJBuilt 1964 · S/N D-7653N1965TWeld Kenneth Jr DBA · Port Orange, FLBuilt 1964 · S/N D-7543N1965ZBushwack Air Inc · Phoenix, AZBuilt 1965 · S/N D-7805N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N197QUrban Andrew W · Sun Prairie, WIBuilt 1965 · S/N D-7930N1985CCollins Bruce J · Caldwell, TXS/N D-7438N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243N19ABYong Andrew · Newnan, GABuilt 1964 · S/N D-7701N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N1BWMbs Ventures Inc · Wilmington, DEBuilt 1977 · S/N D-9963N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328N1SKWienhoff Kevin Bruce · Salem, ORS/N D-9339N1UZJet X Leasing Inc · Johnson, KSBuilt 1964 · S/N D-7420N1WFRegistered aircraftBuilt 1968 · S/N D-8880N1YRPerley Kevin G Trustee · Sioux City, IABuilt 1975 · S/N D-9797N2001BBangert Computer Systems Inc · Shawnee, KSBuilt 1966 · S/N D-8216N2001WCyrus Ely G · Kiana, AKBuilt 1965 · S/N D-7965N2002WWilliams Howard Dale II · Oklahoma City, OKBuilt 1965 · S/N D-7988N2004WPeter Schiff Aero Inc · Cookeville, TNBuilt 1965 · S/N D-7966N2008WSiamese Cat LLC · Issaquah, WABuilt 1965 · S/N D-7977N200BWGas Aviation LLC · Decatur, TNBuilt 1965 · S/N D-7954N2012WIron Compass LLC · Highland Park, MIBuilt 1965 · S/N D-7971N2015WKrosswind Aviation LLC · Cape Coral, FLBuilt 1965 · S/N D-7975N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209N2016Y2016y LLC · Aurora, COBuilt 1978 · S/N D-10157N2017PBruninga Harold J · Jacksonville, ILBuilt 1978 · S/N D-10156N201JHSpero Alan J · Ramona, CABuilt 1966 · S/N D-8113
Back to AD 75-01-07