AD 97-01-13

Registered aircraft · 54,837

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-01-13')
    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-01-13')
  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.

N1881YSutton Aircraft Salvage LLC · Palmer, AKBuilt 1962 · S/N 17249481N1882XWagner Robert W · Casper, WYBuilt 1965 · S/N 18255982N1882YDunlap Alexander W · Eads, TNS/N 17249482N1882ZConstable William H · Rch Palos Vrd, CABuilt 1962 · S/N 205-0082N1883FAnkeney Scott · Canyon, TXBuilt 1966 · S/N 21058783N1883QMitchell Philip J · Arlington, TXS/N 177RG0283N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781N1884XKaines John L · Ludington, MIBuilt 1965 · S/N 18255984N1885MLittle Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 18264468N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782N1887FHeadings Kevin · Echo, ORS/N 21058787N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287N1887ZDavidson David R · Sutton, AKS/N 205-0087N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288N1889FPiper Henry Burton Jr · Kingston, TNBuilt 1966 · S/N 21058789N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783N188DFArc Holdings LLC · Grand Junction, IABuilt 1984 · S/N 425-0188N188GCZuni LLC · Kirkland, WABuilt 2010 · S/N 208B2210N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N188HS&T Aviation LLC · Santa Teresa, NMS/N 50652N188HTReady Aim Flyer LLC · New Castle, DEBuilt 1979 · S/N T18803430TN188PLe Duc Richard Steven · Mazama, WABuilt 1963 · S/N P17257122N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N189Jones William Cody · Roxton, TXS/N P3370209N1890MPutney Bruce N · Midlothian, TXS/N 33701490N1890ZAlaniz Jose M · Yreka, CABuilt 1962 · S/N 205-0090N1891MStarkman Timothy S · Monterey, CABuilt 1975 · S/N 18264470N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491N1892FPanagotacos George · Corona, CABuilt 1966 · S/N 21058792N1892VSmith Air Inc · Ukiah, CABuilt 1974 · S/N 17263784N1892XCuvar Philip M · Granite City, ILBuilt 1965 · S/N 18255992N1892YBaker David Laurence · Nelson, WIS/N 17249492N1893FKleeman Mark · Kearney, MOFirst renewal noticeS/N 21058793N1893QSauk Prairie Aviators LLC · Merrimac, WIBuilt 1972 · S/N 177RG0293N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N1894XCorso Aviation LLC · Southlake, TXBuilt 1964 · S/N 18255994N1894ZEverly Peter · Fort Smith, ARBuilt 1962 · S/N 205-0094N1896XSmr Holdings LLC · Martinsburg, WVBuilt 1964 · S/N 18255996N1896YArmond Richard Joseph · Thousand Oaks, CABuilt 1962 · S/N 17249496N1897QGuadarrama Joe R · Vacaville, CABuilt 1972 · S/N 177RG0297N1897VBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263785N1898XScott Ayer Interests LLC · Phoenix, AZBuilt 1982 · S/N R18201898N1898ZSmart Robbie A · Wasilla, AKBuilt 1962 · S/N 205-0098N1899MLoki Adventures LLC · Norwood, COBuilt 1975 · S/N 18264472N1899QAlvord Jeffrey C · Tucker, GABuilt 1972 · S/N 177RG0299N1899SBuon Volo LLC · Queen Creek, AZBuilt 1971 · S/N 177RG0045N1899ZLarlee Coleman R · Millbrook, ALBuilt 1962 · S/N 2050099
Back to AD 97-01-13