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.

N3465GGv Air Inc · Medford, ORS/N 310R0844N3471GPage Garrett A · Rhodes, MIBuilt 1976 · S/N 310R0845N3472GLosko Patrick J · Tustin, CABuilt 1976 · S/N 310R0846N3473GThayer John P · Columbus, GABuilt 1976 · S/N 310R0847N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597N350CHFly Bye LLC · Georgetown, DEBuilt 1973 · S/N 310Q0910N350JCWear On Earth Aviation LLC · Potsdam, NYBuilt 1975 · S/N 310R0606N350SDAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1970 · S/N 310Q0065N3517GGv Air Inc · Medford, ORS/N 310R0860N3522GJ.A. White & Son Aviation LLC · Powder Springs, GAS/N 310R0862N3556GBenard Richard D · Lakeville, MAS/N 310R0869N355SCSmith Loren D · Great Falls, MTBuilt 1973 · S/N 310Q0795N3563GSkaya Aircraft LLC · Kalispell, MTS/N 310R0871N3587GAtor Robert W · Beach City, TXS/N 310R0874N358MNKeystone Aerial Surveys Inc · Philadelphia, PAS/N 310R0881N363RMMash Kity J LLC · Grand Rapids, MIBuilt 1974 · S/N 310R0046N3640GTailwind Flight Center - Sue LLC · Sturgeon Bay, WIBuilt 1977 · S/N 310R0880N364NYMarc Inc · Bolton, MSS/N 310R-0718N367ATL&R Aircrafts Corp · Boynton Beach, FLBuilt 1972 · S/N 310Q0522N36846Armbruster LLC · Amherst, OHBuilt 1979 · S/N 310R1600N36862Linville Keith · Bend, ORBuilt 1979 · S/N 310R1605N3696GTfa Holding Corp · Daytona Beach, FLS/N 310R0898N36EWSalzer Dustin J · Weatherford, TXS/N 310Q0521N36KWEastern Aviation Publishing Inc · Center Harbor, NHS/N 310R0296N3705GSouthern Illinois University DBA · Murphysboro, ILS/N 310R0900N3720GPersonal Space Aviation LLC · Nokomis, FLBuilt 1977 · S/N 310R0955N37237Hudson Bay Holdings LLC · Lebanon, TNBuilt 1977 · S/N 310R0968N37242Sol Aerial Surveys LLC · Las Vegas, NVS/N 310R0969N37256Patriot Air Inc · Belleville, ILBuilt 1977 · S/N 310R0977N37268H & S Aircraft LLC · Lewes, DEBuilt 1977 · S/N 310R0983N372CCLemieux Kenneth G · Oneida, TNBuilt 1974 · S/N 310Q1071N372FCHeartland Aviation Inc · Alliance, NEBuilt 1971 · S/N 310Q0215N372NMShelter Michael R · Sandy Lake, PABuilt 1970 · S/N 310Q0115N3731GMaxwell Truck & Equipment LLC · State College, PABuilt 1977 · S/N 310R0906N3744GValiair Limited Co Trustee · Casper, WYBuilt 1977 · S/N 310R0909N374TAVintage Aero Inc · Brandon, FLBuilt 1974 · S/N 310Q1105N377CEMetal Mistress Aviation LLC · Meadowview, VABuilt 1976 · S/N 310R0631N3796GSantos Aviation LLC · Chico, CABuilt 1977 · S/N 310R0914N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916N3828GChoice Aviation LLC · Hamilton, MTS/N 310R0923N3835CPreferred Airparts LLC · Apple Creek, OHBuilt 1973 · S/N 310Q0671N3844CMansfield Heliflight Inc · Milton, VTS/N 310R1238N3995AMccoy Keith · Salt Rock, WVBuilt 1978 · S/N 310R1347N3999SViking Aviation LLC · Kindred, NDBuilt 1978 · S/N 310R1292N39BTMidwest Aerial Photography · Galloway, OHBuilt 1974 · S/N 310Q1137N3TQAbove Blue Line LLC · Austin, TXBuilt 1973 · S/N 310Q0752N3VJMiasnikowicz Victor · Lancaster, PABuilt 1973 · S/N 310Q0746N400DPLindsey Russell R · Abilene, TXS/N 310R0268N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634
Back to AD 75-23-07