AD 90-02-13

Registered aircraft · 3,863

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:90-02-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:90-02-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.

N184PSStrama Aviation LLC · Ocala, FLBuilt 1965 · S/N 310J0111N184XTitan Island Aviation LLC · Houston, TXS/N 421C0824N1852EMarshall Dennis Ray Jr · Pottsboro, TXS/N 310R1587N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956N1862TBradley Max T II · West Plains, MOBuilt 1959 · S/N 35962N1865SPima County Board Of Supervisors · Tucson, AZS/N 310R0897N186THSandy Hook Aviation LLC · Sandy Hook, MSBuilt 1966 · S/N 310L-0029N1873HBlue Canoe Aviation LLC · Chicago, ILBuilt 1952 · S/N 35973N1879ERaw Racing Inc · Puyallup, WAS/N 340A0658N1879HRegan Robert C · Kent, WABuilt 1959 · S/N 35979N187WWOsprey Aviation LLC · Riva, MDBuilt 1971 · S/N 310Q0252N1886HGoodwin Joseph N · Grass Valley, CABuilt 1959 · S/N 35986N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100N189MWWilliamson Aviation Inc · Tullahoma, TNBuilt 1968 · S/N 310N-0003N18BKShandog Air LLC · Ashland, KYS/N 310R0981N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557N18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeBuilt 1975 · S/N 310R0560N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503N18VUVincennes University · Vincennes, INBuilt 1977 · S/N 310R0928N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668N1919JValiair Lc Trustee · Casper, WYBuilt 1979 · S/N 310R1554N1919LSmith Sydney O · Lithonia, GAS/N 411-0157N191CTBessemer Plywood Corp · Bessemer, MIBuilt 1974 · S/N 310R0057N191RAnderson Harold E · Phoenix, AZBuilt 1955 · S/N 35229N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496N193DC310 Charter LLC · Zanesville, OHBuilt 1980 · S/N 310R1885N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842N1944EHans Construction LLC · Lititz, PAS/N 340A0675N1944GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0844N1946GPartwin421 LLC · Greenwich, CTBuilt 1974 · S/N 421B0846N1956Sturges George S Jr · Bakersfield, CABuilt 1956 · S/N 35337N196CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0116N196FSTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 421C0501N196RLunsford Joel T · Jasper, TXBuilt 1955 · S/N 35049N196TCClements Dylan A · Burlington, WIBuilt 1980 · S/N 310R1801N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544N1995GHarris Justin R · Hico, TXFirst renewal noticeBuilt 1974 · S/N 414-0602N19AFBegley Edward R · Glasgow, KYBuilt 1966 · S/N 310K0100N19DBDcs Air LLC · Pulaski, WIBuilt 1972 · S/N 310Q0668N19DJLewis Landon Jon · Hope, NDBuilt 1977 · S/N 310R0868
Back to AD 90-02-13