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.

N521DZSchultz Charles J · Juneau, AKBuilt 2012 · S/N 3147N521ER521er LLC · Blaine, MNBuilt 2001 · S/N 172S8924N521FCStevens Kole · Sebec, MEBuilt 2008 · S/N 001N521GTNeptune Skies LLC · Little Elm, TXBuilt 1974 · S/N 17262819N521JDH&G Farms Inc · Corcoran, CABuilt 1998 · S/N 172S8027N521KSKs Flying Club Inc · Manhattan, KSBuilt 1999 · S/N 17280519N521LDStar Marianas Air Inc · Tinian, MPBuilt 1977 · S/N 17269184N521QJJacobi John W · Fort Collins, COBuilt 2016 · S/N 001N521RLCherry Creek School District No 5 · Greenwood Village, COS/N 0216N521RSJj Airlift Inc · Broomfield, COBuilt 2006 · S/N S1891N521TAnderson Oluf J · Rangely, COS/N NAV-4-2244BN521TDRaiders-Tigers Flying Club · Houston, TXBuilt 1969 · S/N 17258636N521TRRizzo Anthony M · Winter Haven, FLS/N DMO379N521TTCaras Tiger LLC · Homestead, FLS/N 10128N521YTDelcavu LLC · Dover, DEBuilt 1943 · S/N 1311N52200Pol Guillermo L · Miami, FLBuilt 1980 · S/N 17274433N5220BFolbre Frank S · Millsap, TXS/N 1083N5220LR & J Services LLC · Tracy, CABuilt 1967 · S/N 28-4513N5220MCummings Brian · Opelousas, LABuilt 1980 · S/N 15284506N5220PStancil Thomas E III · Winterville, NCBuilt 1958 · S/N 24-247N5220RChaz L Enterprises LLC · Ringwood, NJBuilt 1974 · S/N 17263434N5220THammond Michael R · Tigard, ORS/N 28-7225360N5220WHosemann Aaron · Riverview, FLBuilt 1961 · S/N 28-257N5220XCartwheel Aviation LLC · Boise, IDBuilt 1992 · S/N 694-92N52210Pressly Joel D · Sunriver, ORS/N 24129N52217Mustang Sally Aviation LLC · Camden, SCBuilt 1980 · S/N 17274441N52218Jej Leasing LLC · Bangor, MEBuilt 1980 · S/N 17274442N52219Warren Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274443N5221EAir Capital Aviators Club · Wichita, KSBuilt 1978 · S/N 17271778N5221KYoung Gregory · Spring, TXBuilt 1950 · S/N NAV-4-2121BN5221LVeritable Solutions LLC · Bremerton, WABuilt 1967 · S/N 28-4514N5221RDunaway Jeffrey W · Bremerton, WABuilt 1974 · S/N 17263435N5221WGrady John M · Perham, MNBuilt 1961 · S/N 28-258N5221XVandegrift Robert W · Waynesboro, VABuilt 1969 · S/N 200N52220Meyer Jeffrey K · Osceola, WIBuilt 1980 · S/N 17274444N5222DRegistration Pending · Muncie, INRegistration pendingBuilt 1979 · S/N 17272456N5222HDavidson Gerald W · Okatie, SCBuilt 1949 · S/N 16-24N5222JFlywyo LLC · Kalispell, MTBuilt 1980 · S/N 17273738N5222PGharazeddine Raja N · Kaplan, LABuilt 1958 · S/N 24-249N5222ZSaltzman John D · Gilbert, AZBuilt 1961 · S/N 22-8897N5223HSzorek Evelyn Personal Representative · Fairbanks, AKBuilt 1949 · S/N 16-25N5223LN5223l LLC · Cheyenne, WYBuilt 1980 · S/N 15284279N5223RN5223r LLC · Opa Locka, FLBuilt 1974 · S/N 17263437N5223TBarnard Kevin D · Columbia Station, OHBuilt 1972 · S/N 28-7225362N5223WStover Jeffrey Wayne · Gastonia, NCBuilt 1961 · S/N 28-260N52245Poursartip Nader · Hayward, CABuilt 1975 · S/N 164-75N52248Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274458N5224KAri Ben Aviator Inc · Fort Pierce, FLBuilt 1980 · S/N 17274018N5224LWight John M · Merrimack, NHBuilt 1967 · S/N 28-4518N5224TPerkins Barber Shop · Jennings, LABuilt 1972 · S/N 28-7205248
Back to AD 90-04-06 R1