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.

N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649N5819VHoefly Christopher S · Belleview, FLBuilt 1943 · S/N 75-8007N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997N5819ZCristando Robert J · Wolfeboro, NHBuilt 1963 · S/N 22-9676N581BLGrundy Dennis E · Danville, INBuilt 2016 · S/N 20133N581COn Call Aviation LLC · Brentwood, TNBuilt 2003 · S/N 1271N581CHHill Judith L · Carriere, MSBuilt 2010 · S/N 80581N581DMTichy Thomas H · Albuquerque, NMBuilt 2002 · S/N 894-2002N581ESQuinby Alan D · Woodward, OKBuilt 1978 · S/N 17271811N581FAbj Holdings LLC · Buckeye, AZBuilt 1998 · S/N 1407N581JDAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1995 · S/N 21912N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916N581MTMiddle Tennessee State University · Murfressboro, TNBuilt 2004 · S/N 40.397N581NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496258N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115N58206Kiwi Choppers LLC · Hillsboro, ORBuilt 1978 · S/N 190768N58208Smith Helicopter Inc · Cotulla, TXBuilt 1979 · S/N 390780N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000N5820ZWilson Jonathon D · Breckenridge, MIBuilt 1963 · S/N 22-9677N5821HFifer Lucas J Trustee · Charlestown, INS/N 16-437N5821PCummings Mark R · Laveen, AZS/N 121N5821WEnander Johannes T · Grenora, NDS/N 28-2033N5822DFranz Stanley E · Yakima, WABuilt 1956 · S/N 22-4497N5822MKuenzi Steven M · Alamogordo, NMBuilt 1984 · S/N 01N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653N5822ZHogan Gerard T · Rockford, ILBuilt 1963 · S/N 22-9679N5823AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496260N5823QRegistered aircraftBuilt 1965 · S/N 777N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070N5824DWitthuhn Johnie B · Callaway, NEBuilt 1956 · S/N 22-4499N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107N58250Gulick Stephen P · Burlington, VTBuilt 1985 · S/N 50N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025N5825QHobgood Joel A · Sharpsburg, GABuilt 1965 · S/N 778N5825TTeshima Mark William · Clovis, NMS/N 28-1595N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657N5827DNurge Richard · Gilroy, CAS/N 22-4502N5827QPromises LLC · Pompano Beach, FLBuilt 1965 · S/N 859N58281Lueck Thomas J · Cedar Rapids, IABuilt 1978 · S/N 1180734N58285Shields Randolph C · Benton, KSS/N 77-103
Back to AD 90-04-06 R1