AD 90-04-06 R1

Registered aircraft · 68,377

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-04-06-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-04-06-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.

N548TFrasier Samuel R · Gainesville, FLBuilt 1961 · S/N TD-455N54905905 Cess LLC · Wilmington, DEBuilt 1981 · S/N 17275076N5490BMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 15283884N5490HSuperior Flying Services LLC · Superior, WIS/N 17265462N5490NHughes David A · Keller, TXBuilt 1944 · S/N 77-473N5490WHobbs Alicia · Folsom, CABuilt 1962 · S/N 28-575N54910Somboonsap Patanapong · Oakland Park, FLBuilt 1981 · S/N 17275077N5491HSky Hogs LLC · Orange Park, FLBuilt 1975 · S/N 17265463N5491KSale Reported · Rowland, NCSale reportedBuilt 1980 · S/N 17274156N5491LWinter Sarah A · Hurst, TXBuilt 1980 · S/N 15284321N5491PKs Aviation Inc · Atwater, CABuilt 1981 · S/N 15284958N54921Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 76-366N5492HAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1975 · S/N 17265464N5492WSky Park Cherokees Inc · Felton, CABuilt 1962 · S/N 28-577N54933Sammy Supercub LLC Series B · Reno, NVS/N 18-7709022N54938Lentsch Bill · Fairbanks, AKBuilt 1977 · S/N 18-7709024N54939Lang Madison S · Harper, TXBuilt 1976 · S/N 18-7709025N5493RFreedom Flight Center Inc · Hardy, NEBuilt 1979 · S/N 172RG0064N5493ZMcnabb James A Trustee · Grove, OKBuilt 1962 · S/N 22-9278N54946Goosfraba LLC · Huddleston, VABuilt 1981 · S/N 17275084N54947Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275085N5494LZee Sutherland L · Stallings, NCBuilt 1973 · S/N AA5-0394N5494PHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 15284959N5494ZLanham William B · Mineral Wells, TXBuilt 1962 · S/N 22-9279N54950Allen April Elizabeth · Chardon, OHBuilt 1942 · S/N 75-1720N54951Skylens LLC · Hammond, LABuilt 1981 · S/N 17275087N54955Space 5 LLC · Fayetteville, GABuilt 1982 · S/N 17275089N54956Fluke Dennis M · Sunset, TXBuilt 1981 · S/N 17275090N5495DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272587N5495EScotts Helicopter Services Inc · Le Sueur, MNBuilt 1964 · S/N 1916N5495HPeirce Kellie N · Mc Grath, AKBuilt 1950 · S/N 18-86N5495KI Fly High LLC · Mesa, AZBuilt 1980 · S/N 17274160N5495QNovember Sierra Aviation LLC · Oneill, NES/N 15285113N5495THill Mark D · Magnolia, TXS/N 28R-7235236N5495WWings Over Lake Norman LLC · Mooresville, NCBuilt 1962 · S/N 28-580N5495ZHayes Robert L · Chesapeake, VABuilt 1962 · S/N 22-9281N54960First Eclipse Ltd · Richmond, VAS/N 17275092N54968Kangas Kevin L · Fairbanks, AKBuilt 1976 · S/N 18-7709026N5496HWilson Charles L · Seattle, WABuilt 1975 · S/N 17265466N5496LRoda Richard H · Wakefield, RIBuilt 1973 · S/N AA5-0396N5496WMaddux Dawayne E · Weeki Wachee, FLBuilt 1962 · S/N 28-582N5496YAmundson Nancy F · Chugiak, AKBuilt 1952 · S/N 22851N54972Snider Scott E · Turner, MTBuilt 1976 · S/N 18-7709027N5497LCardelli Steve V · San Bruno, CABuilt 1973 · S/N AA5-0397N5497WJethro Charter Flights LLC · Jacksonville, NCBuilt 1962 · S/N 28-583N5497ZShira Daniel C · Homedale, IDBuilt 1962 · S/N 22-9283N54983Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275098N5498HGulf Atlantic Airways Inc · Gainesville, FLBuilt 1975 · S/N 17265468N5498WBas Part Sales LLC · Greeley, COS/N 28-584N5498ZCunningham Florence Jean · Spokane Valley, WAS/N 22-9284
Back to AD 90-04-06 R1