OpenAirDocs.org
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.

N1007XD&R LLC · Emory, TXS/N 34-7570182N1024U24u Aviation LLC · Wilmington, DEBuilt 1971 · S/N 34-7250004N102LLExecutive Aviation LLC · Peoria, AZS/N 34-7970483N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026N1044HWiebe Farms Inc · Hooker, OKS/N 34-7770100N104JHDouble Helix Solutions LLC · Kamuela, HIS/N 34-7670163N104WPMartyn Christian A · Hallendale, FLBuilt 1977 · S/N 34-7870048N1054UDippolito Thaddeus M · Sherwood, ARBuilt 1971 · S/N 34-7250038N1054XMurphy George E · Robinson, ILBuilt 1975 · S/N 34-7570195N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199N1078UHigh Flight Academy LLC · Allison Park, PABuilt 1972 · S/N 34-7250078N107ABHobart Aviation Inc · Akron, OHBuilt 1977 · S/N 34-7770341N109WESpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 347870405N10BNBlack Thomas D DBA · Clearwater, FLBuilt 1975 · S/N 34-7570050N10NZConnor Reginald W · The ValleyNon-citizen corporation, flight hours not reportedS/N 34-7870158N10PBNeves Frank Jr · North Miami Beach, FLBuilt 1974 · S/N 34-7570031N1106XVan Vleet Merlin D · Kingman, AZBuilt 1975 · S/N 34-7570212N110CAFargo Jet Center LLC · Fargo, NDBuilt 1975 · S/N 34-7570219N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117N111PHGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 34-7970001N111RXThompson William · Tampa, FLS/N 347770134N111SMMuller Aviation LLC · New Baltimore, MIBuilt 1977 · S/N 34-7770333N1142XAerofeather Aviation Inc · Suffolk, VAS/N 34-7570221N114JRN114jr LLC · Canyon Lake, CABuilt 1975 · S/N 34-7570152N1162XSeeding Operations And Atmospheric Reseach LLC · San Angelo, TXBuilt 1975 · S/N 34-7570225N1166XEagle Aviation Inc · Tucson, AZBuilt 1975 · S/N 34-7570227N1176XLyvers Joseph D · Louisville, KYBuilt 1975 · S/N 34-7570231N1194XCantrell William Terry · Spring Hill, TNS/N 34-7570236N11HRHf Aero LLC · Lusby, MDBuilt 1979 · S/N 34-7970233N11YNN3412w LLC · Lithia, FLS/N 34-8070059N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265N121WAWeather Modification LLC · Fargo, NDBuilt 1979 · S/N 34-7970435N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267N1230TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250268N1234UInternational Air Services Inc Trustee · Carson City, NVS/N 348070336N1239TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250270N123APJc Air Academy Inc · Stockton, CABuilt 1977 · S/N 34-7770015N125FLAll Star Capital LLC · Concord, NCBuilt 1980 · S/N 34-8170025N1265HKingsky Flight Academy LLC · Lakeland, FLS/N 34-7770117N1278HMetzner Brad · Visalia, CAS/N 34-7770118N1293TN1293t LLC · Wilmington, DES/N 34-7250283N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309N1316ASky West Aviation Inc Trustee · Albuquerque, NMS/N 347770258N132CTHanger Six LLC · Birmingham, ALBuilt 1978 · S/N 34-7870179N1334HPreskar Michael H · Ione, CABuilt 1977 · S/N 34-7770121N134ACSkyline Solutions Inc · Deland, FLBuilt 1972 · S/N 34-7350014N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301N1380TN1380t LLC · Wilmington, DEBuilt 1972 · S/N 34-7250302
Back to AD 75-20-03