OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N1653PAirmotive Service LLC · Brigham City, UTBuilt 1954 · S/N 18-3768N16547Mickle Charles R · Hinton, OKS/N 28-7325297N16548Watchman Aviation LLC · Pierceton, INBuilt 1973 · S/N 28-7305280N1654GGelvin Stanley M · Central, AKBuilt 1968 · S/N 123N1654JStygar Richard M · Coal City, ILBuilt 1967 · S/N 28-24049N16551Mike Smith Construction Inc · Holyoke, COBuilt 1973 · S/N 28-7305283N16554Sk Group LLC · Moore, SCBuilt 1973 · S/N 28R-7335162N16555Vampola Timothy D · Bellevue, NEBuilt 1973 · S/N 28R-7335163N1655AConnell Romeao J · Gresham, ORS/N 22-419N1655JGallant Arthur · Kingston, NHBuilt 1967 · S/N 28-24051N16560Wasson Tom L · Lakeport, CABuilt 1973 · S/N 28-7325298N16564Bradley Jason · Fort Mohave, AZBuilt 1973 · S/N 28-7305285N16566Schaumberg John · Lebanon, INS/N 28R-7335164N1657EMcghee David L · Oklahoma City, OKBuilt 1978 · S/N 17271085N16583Gawlikowski Joseph J · Spearfish, SDBuilt 1973 · S/N 28-7325301N1658EBrockwell Jesse A · Disputanta, VABuilt 1978 · S/N 17271086N1659ARowell Tony A · Westerville, OHBuilt 1952 · S/N 22-415N1659GMills Kurt E · Oak View, CABuilt 1968 · S/N 632N1659JHanger C22 LLC · Hillsboro, ORBuilt 1968 · S/N 28-24056N165ACBrian & Karen Snodgrass Farms LLC · Seminole, TXS/N 471-2005N165AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010059N165AZBoyko Flying Services LLC · Ruso, NDBuilt 1964 · S/N 433N165BCMckinney William C · Whitefish, MTBuilt 2019 · S/N 600-2019N165DHSchultz Christopher N · Cheyenne, WYBuilt 2002 · S/N 165N165EZVissers Jacob A · Saint Peters, MOBuilt 1987 · S/N 165N165FTParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216195N165GAWilke Harley D · Bullard, TXS/N 2106N165HRSecond Wind LLC · Palm City, FLBuilt 1994 · S/N 20923N165JCSmoketown Helicopters LLC · Smoketown, PAS/N 0146N165JLLevi Jonathan A · Fallbrook, CABuilt 2007 · S/N 165N165JMCorell Glen · Freeland, WABuilt 2003 · S/N 81393N165JYSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1977 · S/N 28-7890225N165LHRochester Air Center LLC · Canandaigua, NYBuilt 2011 · S/N 2844144N165MSmith Steven J · Naperville, ILBuilt 1993 · S/N 1092N165MPPike Martin C · Mountain Home, IDBuilt 1992 · S/N 165N165PSPhindogair LLC · Lubbock, TXBuilt 2005 · S/N 40.523N165RAEl Rancho Escondido Inc · Brownsville, TXBuilt 2004 · S/N 1367-2004N165TGrove Robert P · El Cajon, CABuilt 1953 · S/N 18-2279N165YPSpanaflight LLC · Puyallup, WABuilt 1999 · S/N 17280752N1660GHintzman Bonnie L · New York Mills, MNBuilt 1968 · S/N 633N1660PJanvrin Jerry M · Buffalo, SDBuilt 1954 · S/N 18-3782N1660VOdegaard Wings Inc · Kindred, NDBuilt 1974 · S/N 17263705N1661GLockbaum James G · Oconomowoc, WIBuilt 1968 · S/N 636N1661NSs Farms Operating LLC · Hydro, OKS/N TC0703010N1661PFrost John David Trustee · Anchorage, AKBuilt 1954 · S/N 18-3783N1662JAltaverde LLC · Port Orange, FLBuilt 1967 · S/N 28-24059N1662PRyan Dietrich Farms Inc · Scottsbluff, NEBuilt 1954 · S/N 18-3784N16635Jeepers LLC · New York, NYBuilt 1967 · S/N 758780N1663POakes Stephen · Joshua Tree, CAS/N 22-3089N1664GTownsend Virgil P · Yukon, OKBuilt 1968 · S/N 645
Back to AD 90-04-06 R1