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.

N434LQualitair LLC Trustee · MichelstadtS/N D-8694N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620N436EButcher Gregory E · Pensacola, FLBuilt 1964 · S/N D-7532N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256N4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141N440DDeeble Kenneth M · Dayton, MTBuilt 1964 · S/N D-7461N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911N440QB&T Aviation LLC · Columbia, SCBuilt 1964 · S/N D-7410N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142N4419AMccants Robley D · Mesa, AZS/N D-9147N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606N4432ABrown David L · Gold Hill, NCBuilt 1970 · S/N D-9144N4435VMacdonald Glenn · Sugar Land, TXFirst renewal noticeBuilt 1979 · S/N D-10225N4444KSivyllis Costas · Port Orange, FLFirst renewal noticeBuilt 1964 · S/N D-7422N444AFContinental Aero Associates Inc · Grosse Pointe Park, MIBuilt 1974 · S/N D-9590N444DGSwanson Douglas A · Marana, AZS/N D-9882N444DKPiggott Russell T · Fresno, CABuilt 1979 · S/N D-10296N444DWTriple 4 Dw LLC · Davie, FLBuilt 1972 · S/N D-9416N444RUFitzgerald Paul · Grapevine, TXBuilt 1973 · S/N D-9441N444TCHalstead Land & Cattle Inc · Arnold, NEBuilt 1975 · S/N D-9783N444WRNuccio Jeffrey W Trustee · Signal Mountain, TNBuilt 1977 · S/N D-10012N4452WHubbard Mark A · Wilmington, DEBuilt 1974 · S/N D-9611N4457SRegistered aircraftBuilt 1975 · S/N D-9775N4458ARaimondi Johann I · Doral, FLBuilt 1970 · S/N D-9145N4466SRegistration Pending · West Monroe, LARegistration pendingS/N D-9779N4468WBorth John D · Meade, KSBuilt 1974 · S/N D-9604N446RDwons Roland Joseph · Oro Valley, AZS/N D-8474N446TThatcher James W · La Canada Flt, CABuilt 1970 · S/N D-9164N4470SFreitag Don M · Manhattan Beach, CABuilt 1975 · S/N D-9778N4479SN4479s LLC · Nashville, TNBuilt 1975 · S/N D-9790N4484WRegistered aircraftBuilt 1974 · S/N D-9581N4485SDickerson Stephen Sr · Frisco, TXBuilt 1975 · S/N D-9785N4486SPopadich Nicholas · Monroe, MIBuilt 1975 · S/N D-9788N4486WReynolds Eric Eugene · Weatherford, TXBuilt 1969 · S/N D-9070N448JDavenport James A · San Antonio, TXBuilt 1966 · S/N D-8127N4493SRudrud David O Trustee · Scottsdale, AZBuilt 1975 · S/N D-9792N4494WConlon James E Jr · Troy, NYBuilt 1974 · S/N D-9614N4496SHme Holdings Group LLC · Franklin, INBuilt 1975 · S/N D-9793N449TSmallwood David · Oak Ridge, TNBuilt 1970 · S/N D-9153N44CMRussell Stephen J · Chester, VTBuilt 1969 · S/N D-8927N44PBMcpeck Adam S · Agar, SDFirst renewal noticeBuilt 1964 · S/N D-7678N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115
Back to AD 75-01-07