AD 97-07-03

Registered aircraft · 605

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:97-07-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:97-07-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.

N138RA & K Aviation LLC · Wenatchee, WABuilt 1972 · S/N 317300935N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411N13ESCsl Holdings LLC · Drayton, NDBuilt 1977 · S/N 31-7812046N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117N144ASValiair Lc Trustee · Casper, WYBuilt 1973 · S/N 31-7300903N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005N1470BBerger Leo · Nampa, IDS/N 31-7512061N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104N159DSynapse USA LLC · Mesa, AZBuilt 1974 · S/N 31P7530012N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005N16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVBuilt 1970 · S/N 31-639N16YPSebastian Aero Services Inc · Guaynabo, PRBuilt 1982 · S/N 31-8252008N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074N17PSNorris C · Land O Lakes, FLBuilt 1976 · S/N 31P-7630008N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053N189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 31-7512045N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138N196AGMarc Inc · Bolton, MSS/N 31-7952036N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124N200PVPrestwick Chase Inc · Saratoga Springs, NYBuilt 1971 · S/N 31P-64N200RARagan William W · North Kansas City, MOBuilt 1974 · S/N 31P7400198N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025N207MDGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612092N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121N212RAAbin Ricardo · Miami Lakes, FLBuilt 1977 · S/N 317712057N213ACRtb Transport LLC · Evans, GABuilt 1984 · S/N 31-8452011N21406Makushin Logistics LLC · Fairbanks, AKS/N 31-7752117N21ABAriel J Quintela LLC · Odessa, FLBuilt 1980 · S/N 31-8052122N21HGDrisco LLC · Ponca City, OKBuilt 1981 · S/N 31-8152078N21HLChieftain Aviation Inc · Marietta, GAS/N 31-8152126N221ACAusten Air LLC · Lees Summit, MOBuilt 1980 · S/N 31-8152045N225TMSouth Of Snow Adventures LLC · Hartwell, GAS/N 318152165N227AKHanzawa George K · Wahiawa, HIBuilt 1981 · S/N 31-8152198N227ECEcjet Inc · Downey, CABuilt 1974 · S/N 31-7405184N227RMHeli Coral Inc · Wilmington, DEBuilt 1979 · S/N 31-7912085N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062N234CEAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052203
Back to AD 97-07-03