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.

N1841XBoland Thomas · Pewaukee, WIBuilt 1964 · S/N 18255941N1841YSegroves Chris · Clarkston, WAS/N 17249441N1842QKrause Douglas S · Davis, CABuilt 1971 · S/N 177RG0242N1842SFry William A · Willmar, MNBuilt 1973 · S/N 414-0433N1842XRichey Perry A · Willow, AKBuilt 1964 · S/N 18255942N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743N1843QJohnson Dana J · Winona, MNBuilt 1972 · S/N 177RG0243N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043N1844QT & E Brothers Inc · Gardena, CABuilt 1972 · S/N 177RG0244N1844XSmith James E · Cuba, MOBuilt 1964 · S/N 18255944N1844ZN1844z LLC · Hillsboro, ORBuilt 1962 · S/N 205-0044N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769N1845XFry Richard R · Marana, AZBuilt 1965 · S/N 18255945N1845YAlpha Aviation Holdings Group LLC · Raleigh, NCBuilt 1962 · S/N 17249445N1845ZQuale Scott M · New Town, NDBuilt 1978 · S/N 180-52973N1846QBucciarelli Tazio E · San Diego, CABuilt 1972 · S/N 177RG0246N1846YMuldoon Anthony P · Howell, MIS/N 17249446N1846ZFullerton Thomas M · Centennial, COBuilt 1978 · S/N 180-52968N1847QDye Michael M · Bastrop, TXBuilt 1972 · S/N 177RG0247N1847RNugent Properties LLC · Wasilla, AKFirst renewal noticeBuilt 1974 · S/N 18502562N1847YN1847y LLC · Queensbury, NYFirst renewal noticeBuilt 1962 · S/N 17249447N18481Snowball Medical Inc · Knoxville, TNBuilt 1981 · S/N 425-0105N1848QHartley Paul · Bellevue, WABuilt 1977 · S/N 18503493N1848RTallman Dale C · Wasilla, AKBuilt 1974 · S/N 18502563N1848ZBritt Robert J · Augres, MIBuilt 1962 · S/N 205-0048N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749N1849XRaymond Patrick H · Jerseyville, ILBuilt 1965 · S/N 18255949N184AKDe Man Cameron T · Bend, ORBuilt 1963 · S/N 18051302N184DPRobertson Gary B · Canton, TXBuilt 1975 · S/N 18263817N184JPSarita Aerial Contractors Inc · Casa Grande, AZBuilt 1979 · S/N 18052889N184PWCardwell Aubrey Lynn · Spring Branch, TXBuilt 1979 · S/N 18266871N184TMYates Christopher R · Huntington Beach, CABuilt 1956 · S/N 32302N184XTitan Island Aviation LLC · Houston, TXS/N 421C0824N185Ellison Jeremy Trustee · Dayton, NVBuilt 1974 · S/N 18502582N18500Thompson Dennis E · Anchorage, AKBuilt 1977 · S/N 18503305N18501Dunbar Stephen E Trustee · Broken Arrow, OKS/N 15073894N18502Smith Stewart K · Samson, ALBuilt 1972 · S/N 15073895N18503Asejo Emmanuel · Kaaawa, HIBuilt 1972 · S/N 15073896N18505Webb Terrell W · Albemarle, NCBuilt 1972 · S/N 15073897N18506Mc Carley Kendel · Tucson, AZBuilt 1972 · S/N 15073898N1850QVincz Shawn · Williams, INBuilt 1972 · S/N 177RG0250N18510Moore Jack B · Irvine, CABuilt 1976 · S/N 17702539N18518Sale Reported · Waterbury, CTSale reportedBuilt 1976 · S/N 17702540N18519Chrystall Shane · Marysville, OHBuilt 1972 · S/N 15073909N1851YEscapule Dustin L III · Florence, AZBuilt 1962 · S/N 17249451N18521Island Air LLC · Eagan, MNBuilt 1979 · S/N 185-03812N18522Carr Scott · Bells, TXBuilt 1972 · S/N 15073911N18523Km50 Ventures LLC · Pensacola, FLBuilt 1976 · S/N 17702541
Back to AD 97-01-13