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.

N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497N5425YWilson Leif L · Tok, AKBuilt 1964 · S/N 18-8177N5426Vieira Mark · Turlock, CABuilt 2014 · S/N 1001N54266Low Country Skyways LLC · Wilmington, DEBuilt 1989 · S/N 5-18-42N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132N5426JMedia Stew LLC · Carson City, NVS/N 17273789N5426MWorthington Aras · Anchorage, AKS/N 001N5426QLen Emery Photography LLC · Springfield, VTBuilt 1973 · S/N 17261789N54273Swanson Gary A · Fort Bragg, CABuilt 1981 · S/N 17274938N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133N5427ZRegistration Pending · Dothan, ALRegistration pendingBuilt 1961 · S/N 22-9201N54283Sale Reported · Lewistown, MTSale reportedBuilt 1975 · S/N 18-7509130N54285Monahan Richard J Jr · Budd Lake, NJBuilt 1981 · S/N 17274945N54288Chandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 17274946N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118N5428KTomlin Rollin D · Wilmington, OHS/N NAV-4-2328-BN5428LMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 15284313N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500N54290Laguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 17274948N54291Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17274949N54296Honcho Aircraft LLC · Crosby, TXBuilt 1981 · S/N 17274950N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119N5429LGardner T Larry · Dickson, TNS/N AA5-0502N5429WLafontaine Generator Exchange Inc · La Fontaine, INBuilt 1962 · S/N 28-501N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051N542EClegg Edward T · Standish, MEBuilt 2008 · S/N 82179N542EZLesher Caleb J · Cottonwood, CAS/N 80N542FCooper Nina · Lake Elmo, MNBuilt 2022 · S/N 542N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374N542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 2459MN542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772N542JVBeaubien Matthew L · Sacramento, CABuilt 1999 · S/N 1450N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866N542LHarvey Matthew T · Aiken, SCS/N EDL1N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364N542MJRegistration Pending · Helena, MTRegistration pendingS/N 5511N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099N542RTVerkaik Michael S · Oakdale, CABuilt 2022 · S/N 83342N5430Plowman Arnold H · Willmar, MNBuilt 1976 · S/N GTS-1N54306Aiken Patrick J · West Greenwich, RIBuilt 1981 · S/N 17274951N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120N5430LKanarick Justin · Colleyville, TXBuilt 1973 · S/N AA5-0330N5430MAmi Aviation Inc · Monroe, NYBuilt 1978 · S/N MC-573N5430WAnderson Douglas S · Gansevoort, NYS/N 28-503N5431Reynolds Stuart N II · Sutherland, VABuilt 1970 · S/N 1N54311Daniel Earl F · Ashland, KYBuilt 1981 · S/N 17274952N54319Jones Roddy H · Thomasville, GABuilt 1981 · S/N 17274954
Back to AD 90-04-06 R1