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.

N8171DLueking Clyde F · Holdrege, NEBuilt 1957 · S/N 18-6100N8171NOndrovic Rick · Belton, SCBuilt 1968 · S/N 28-25367N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284N8172Magrini Shawn P · Salem, OHBuilt 1970 · S/N RJB-2N81723Aero Legacy Foundation · Basehor, KSS/N 31047N81729Bushroe Dennis J · Temperance, MIBuilt 1996 · S/N 20847N8172CDrath Mark O · Reedsville, WIBuilt 1954 · S/N 18-3628N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263N8172WMile High Advertising LLC · Dover, DEBuilt 1965 · S/N 28-2294N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264N8173DAaa Flying Service Inc · Wellington, TXBuilt 1957 · S/N 18-6097N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287N81741Corsican Aviation LLC · Westfield, INBuilt 1980 · S/N 28-8090134N81749Friend Aircare Inc · Washington, PABuilt 1982 · S/N 28-8290107N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574N8174WJeffers Coreen · Bellmawr, NJBuilt 1965 · S/N 28-2298N8174YStansbury Todd V · Centennial, COS/N 30-1289N8175CYates Trucking Inc · Quartz Hill, CABuilt 1975 · S/N 28R-7635132N8175EHigh Planes Aviation LLC · Goodland, KSBuilt 1959 · S/N 1446N8175HHowe Richard B · San Luis Obispo, CABuilt 1980 · S/N 28-8016292N8176Lewandowski Mark J · Wilton, CABuilt 1971 · S/N 1207N8176CShaffer Glenn · Vinemont, ALBuilt 1954 · S/N 18-3632N8176NPlane Doc LLC · Phoenix, AZS/N 28-25372N81771Skyfusion II LLC · Atlanta, GABuilt 1980 · S/N 28-8090269N8177NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N 28-25373N8177WDavis James Warren · Albemarle, NCBuilt 1965 · S/N 28-2301N8179DGarza Jose R Jr · West Jordan, UTBuilt 1971 · S/N 177RG0009N8179HSam Air LLC · Daphne, ALBuilt 1982 · S/N 28-8216138N8179NFletcher William J · Mason, NHBuilt 1968 · S/N 28-25375N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879N8179WLynch Gary L · Ocala, FLBuilt 1965 · S/N 28-2303N817AAnderson Jennifer M · Biggs, CAS/N 22-121N817ABHawaii Pacific Aviation Inc · Kailua Kona, HIS/N 1258N817ACCannon Air Force Base - Aero Club · Clovis, NMBuilt 2003 · S/N 2842190N817AKZweifel Brad · Palmer, AKBuilt 1958 · S/N 55101N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003N817FKSimply Living LLC · Fort Myers, FLBuilt 1942 · S/N 77-4N817GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881465N817HAIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280828N817HSMoore Stephen T · Ellensburg, WABuilt 2012 · S/N 91132N817JJenkins Jay T · Burnsville, MNBuilt 1999 · S/N 80017N817JCCain Jerome M · Lincoln, MTBuilt 1999 · S/N 1465N817JVRusyniak Anthony J · Syracuse, NYBuilt 1995 · S/N 1283N817KCCrawford Michael R · Gainesville, GABuilt 1976 · S/N AS-1
Back to AD 90-04-06 R1