OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N297DSWalkinshaw Jason W · Aztec, NMBuilt 2004 · S/N 60297N297DWBlack Mark A · Lawsonville, NCBuilt 2000 · S/N 80601N297MET L B Inc · Howell, NJBuilt 2000 · S/N 172S8556N297MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843863N297NWKight Daniel H · Anderson, SCBuilt 2003 · S/N 81450N297PCTibbitts Adam K · Bountiful, UTBuilt 2010 · S/N 590N297RAShiner Benjamin · Edmonds, WAS/N 5184N297VLewis Rodney · Andalusia, ALBuilt 1966 · S/N 3389N297XWillwerth Lee J · Saline, MIBuilt 1967 · S/N 17700397N29809Timmons David L · Pierre, SDS/N 2658N2980DLimbach Ronald B · Verona, ILBuilt 1980 · S/N 642-80N2980LJentes Charles A · Smithville, OHFirst renewal noticeBuilt 1967 · S/N 670339N2980RSlagle Noah J · Griffin, GABuilt 1969 · S/N 28R-35368N2980ZMckinney Kurt L · Fairbanks, AKBuilt 1959 · S/N 18-7091N29819Brown Warren W · Foley, ALBuilt 1941 · S/N 2668N2981DYoungblood Allyson M · Anchorage, AKS/N 26924N2981ECox William Warren · Collierville, TNBuilt 1978 · S/N 17271394N2981MPavey Rocky A · Fairbanks, AKBuilt 1980 · S/N 360-80N2981PGray Ellie · Anchorage, AKBuilt 1955 · S/N 18-4519N29823Sota Charles G Jr · Kirkland, WABuilt 1941 · S/N 2672N2982LBurgdorf Brandon M · Evansville, INBuilt 1967 · S/N 670341N2982XSale Reported · Lakeland, FLSale reported, canceledS/N 17700382N2983PEastgate Motors Inc · Salem, ORS/N 18-4521N2983XEagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701365N2983ZFisher Charlton D · Houston, TXBuilt 1959 · S/N 18-7094N29847Stith Donald M · Fort Worth, TXS/N 2698N2984MFitts Robert D · Independence, ORBuilt 1946 · S/N 12-1369N2985LHeskett Sean D · Steamboat Springs, COBuilt 1967 · S/N 670344N2985THuskey Ryan J · Guthrie, OKBuilt 1967 · S/N 059N2985WWildhorse Helicopter Company Inc · Pendleton, ORBuilt 1972 · S/N 6840N2985XFrazier James R · Adamsville, TNBuilt 1967 · S/N 17700385N2986MHarwood Thomas K · Fairbanks, AKBuilt 1946 · S/N 12-1371N2986PBentley Aero Inc · Wilmington, DEBuilt 1955 · S/N 18-4499N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375N2986ZWharton Betty E · Amarillo, TXFirst renewal noticeBuilt 1959 · S/N 18-7100N2987GMuehlbauer Jeff J · Nenana, AKBuilt 1967 · S/N 578N2987MLonguski Francis J · Vassar, MIBuilt 1946 · S/N 12-1372N2987PSmall Mark B · Walla Walla, WAS/N 18-4500N29885Fife William M Jr · Ocala, FLBuilt 1941 · S/N 2736N29886Lubeck Thomas L · Anchorage, AKBuilt 1941 · S/N 2737N2988BLongobardo Anthony · San Clemente, CABuilt 2012 · S/N 1002N2988PKadrmas Ryan · Dickinson, NDFirst renewal noticeBuilt 1955 · S/N 18-4501N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671N2988WScibelli Christopher S · Southwick, MABuilt 1972 · S/N 25069N2988XDoyle Thomas P · San Diego, CABuilt 1968 · S/N 17700388N2989Reavely Richard T · Madison, CTBuilt 1969 · S/N M-1274N2989XLabadie Enrique L · Tucson, AZBuilt 1967 · S/N 17700389N298ACEagle Prairie Flyers LLC · Eau Claire, WIFirst renewal noticeBuilt 1999 · S/N 1259-99N298BCFlight School Of Gwinnett · Lawrenceville, GABuilt 1978 · S/N ME-59N298CACurtis Caleb K · Pittsfield, MEBuilt 2025 · S/N 80473
Back to AD 90-04-06 R1