AD 75-23-07

Registered aircraft · 827

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-23-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-23-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.

N310UKInternational Air Services Inc Trustee · Carson City, NVS/N 310R-0584N310VGGtc Services LLC · Ocala, FLBuilt 1977 · S/N 310R-0990N310VRWg Aircraft Holding Corp · Daytona Beach, FLBuilt 1976 · S/N 310R0655N310VVMsl Air Inc · Sugar Grove, ILS/N 310R1561N310WDHernandez Jr Raymond Trustee · Burleson, TXBuilt 1969 · S/N 310Q0238N310WGMunro Donald W · Commerce Township, MIBuilt 1972 · S/N 310Q0412N310WHLexington Air Services LLC · Greenwood, MSBuilt 1975 · S/N 310R0074N310WJAg N310wj LLC · South Salt Lake, UTBuilt 1976 · S/N 310R0721N310WSN310ws LLC · Athens, ALBuilt 1975 · S/N 310R0612N310WVHill Rick A · Bridgeport, WVBuilt 1973 · S/N 310Q0976N310XRValiair Limited Co Trustee · Casper, WYBuilt 1976 · S/N 310R0626N310ZFlyin' Dog Air LLC · Niceville, FLBuilt 1979 · S/N 310R1573N311RWWashburn Harrill Gene Jr · Rutherfordton, NCBuilt 1974 · S/N 310R00117N311SKDoyle Thomas Michael · New City, NYBuilt 1976 · S/N 310R0687N312CSFlybuys3 LLC · Lewes, DEBuilt 1977 · S/N 310R0959N313JHJam Three LLC · St George, UTBuilt 1974 · S/N 310Q1011N314BBMarc Inc · Bolton, MSS/N 310R1836N314HBMarc Inc · Bolton, MSBuilt 1979 · S/N 310R1586N314UPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1979 · S/N 310R1852N316RALeading Edge Flight Services Inc · Hampshire, ILBuilt 1974 · S/N 310Q1100N317TRRcs Aeronautical Inc · San Antonio, TXBuilt 1973 · S/N 310Q0787N318UTraffic Law LLC · Tampa, FLBuilt 1977 · S/N 310R0994N3195MAspire Management Inc · New Castle, DEBuilt 1980 · S/N 310R1868N31GKMartin Richard B · Corona Del Mar, CAS/N 310Q0664N31KGMidwest Corporate Air Inc · Bellefontaine, OHBuilt 1978 · S/N 310R1533N31PGPlacette Jim · Houston, TXBuilt 1977 · S/N 310Q0687N31YKJendair LLC · New York, NYBuilt 1973 · S/N 310Q0934N321DWJsj LLC · Wilmington, DEBuilt 1979 · S/N 310R1823N3227ABoho LLC · Lewes, DEBuilt 1980 · S/N 310R1881N326PTJt Aero LLC · Covington, GABuilt 1974 · S/N 310Q0968N3279MValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N 310R1891N3284MSonrise Aviation LLC · Portland, INS/N 310R1892N3288MClute Kenneth N · Las Vegas, NVBuilt 1980 · S/N 310R1895N32TLJonesboro Cycle And Atv LLC · Bone, ARBuilt 1974 · S/N 310R0032N3310DGrewe Mike · Lake In The Hills, ILBuilt 1972 · S/N 310Q-0630N331LSTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 310Q0028N3321MMaxray Aviation LLC · Ashland, OHBuilt 1978 · S/N 310R1343N3322XAllgood Michael K · Saint Augustine, FLBuilt 1974 · S/N 310Q1030N333ESRebus LLC · Andover, KSS/N 310Q0232N3364LLopez Edwin · Germantown, TNS/N 310Q0784N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818N3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1976 · S/N 310R0821N3399QBaron Aviation Corporation · Broad Run, VABuilt 1975 · S/N 310R0304N33VTTjr Aviation LLC · Orefield, PAS/N 310Q0974N340CHAircraft & Aviation Professional LLC · Coldwater, MIBuilt 1979 · S/N 310R1565N3417GDemark Aviation Inc · Wilmington, DEBuilt 1976 · S/N 310R0825N3418GOppermann William A · Derby, KSBuilt 1976 · S/N 310R0826N344AHAdams Flying Service Inc · Rayville, LABuilt 1978 · S/N 310R1371N3458GAmerican Aircraft Sales LLC · Livermore, CAFirst renewal noticeBuilt 1976 · S/N 310R0842N3463GBuckles Robert F · Boseman, MTBuilt 1976 · S/N 310R0843
Back to AD 75-23-07