OpenAirDocs.org
AD 90-13-01 R1

Registered aircraft · 1,150

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

N954TJTx Investments LLC · Fort Lauderdale, FLBuilt 2002 · S/N 4567N95ALLakeland Aircraft Maintenance LLC · Eagle Lake, FLBuilt 1990 · S/N 51360N95SKCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 1921N969RLRanger Aviation Leasing LLC · Wilmington, DES/N 3969N96AEAir Evac Ems Inc · O Fallon, MOBuilt 1982 · S/N 45751N96BHBighorn Flying Co LLC · Wood River, NEBuilt 1982 · S/N 51011N96NWNorthwest Helicopters Inc · Olympia, WABuilt 1995 · S/N 4389N970QHeli Works Flight Services LLC · Deer Lodge, MTBuilt 1988 · S/N 51255N971RHTurbines Ltd · West Point, NEBuilt 1972 · S/N 797N972RHFriend Ships · Galveston, TXBuilt 1976 · S/N 2050N973NANational Aeronautics And Space Administration · Houston, TXS/N 3884N974WBCk Helicopters LLC · Jasper, INBuilt 1974 · S/N 1425N975NANational Aeronautics And Space Administration · Houston, TXS/N 3887N975RHTurbines Ltd · West Point, NEBuilt 1996 · S/N 4415N975TRBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 1235N976NANational Aeronautics And Space Administration · Houston, TXS/N 3889N979HBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 51403N979NFresh Air LLC · Camarillo, CABuilt 1983 · S/N 45777N979RHTurbines Ltd · West Point, NEBuilt 1989 · S/N 4080N97HHMgs Co Inc · Hazle Township, PAS/N 2172N97PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1979 · S/N 2632N97PXIron Horse Aviation LLC · Marshalltown, IABuilt 1984 · S/N 51114N97RRCounty Of Ocean · Barnegat, NJBuilt 1993 · S/N 4287N981RHFly Hangar 13 LLC · Mico, TXBuilt 2008 · S/N 4659N9833FKlump Aviation LLC · Bowie, AZBuilt 1992 · S/N 4205N988LBUpshaw Roy L · Ft Worth, TXBuilt 1993 · S/N 4217N98ALAvere LLC · Twin Falls, IDBuilt 1980 · S/N 2985N98AZBig Tree Aviation LLC · Salem, ORBuilt 1977 · S/N 2296N98CMSk Hoff Enterprises LLC · Wilsonville, ORBuilt 1989 · S/N 4056N98EAOn Target Applicators LLC · Monticello, INBuilt 1973 · S/N 935N98PHOlson Gary Peter · Lanesboro, MNBuilt 1988 · S/N 51254N98SMLewis Donn C · Millington, MIS/N 658N9902KSouthmark Aviation Inc · Hattiesburg, MSBuilt 1976 · S/N 1923N9913KMaine Helicopters Inc · Whitefield, MEBuilt 1976 · S/N 2055N992MRPlatinum Rigging & Hvac Consulting LLC · Covington, GABuilt 1981 · S/N 3265N9944KA Scott Jackson Trucking Inc · Jerome, IDBuilt 1976 · S/N 2001N9953KCoastal Helicopters Inc · Panama City, FLBuilt 1977 · S/N 2150N995KPBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 2572N996MCT C B Properties Ltd · Wilmington, DEBuilt 1981 · S/N 3273N996TVTopside Aviation Inc · Brasstown, NCBuilt 1988 · S/N 4019N9984KJl Aviation Inc · Boring, ORBuilt 1976 · S/N 45054N9993CTemplar Helicopters LLC · Glendale, AZS/N 45682N9993KCivil Air Support LLC · Phoenix, AZS/N 2054N999JHCoastal Equipment Inc · Wellington, FLBuilt 1978 · S/N 2486N99ZASouthmark Aviation Inc · Hattiesburg, MSFirst renewal noticeBuilt 1979 · S/N 2794N99ZFFrokjer Greg M · Absarokee, MTBuilt 1977 · S/N 2145N9QDChemair Helicopters Inc · Jefferson, WIBuilt 1994 · S/N 4306N9VFAtxaviation LLC · Creedmoor, TXBuilt 1986 · S/N 3945N9YJHelicopters Inc · Linden, NJBuilt 1982 · S/N 3672N9ZVL& R Investment Partners LLC · Wilmington, DES/N 3793
Back to AD 90-13-01 R1