OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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-06-03-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-06-03-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.

N51081N51081 LLC · Palm City, FLS/N 17274264N5108FCooper Gerald W · Kennewick, WABuilt 1965 · S/N 17252727N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705N51092Sylvania Airport LLC · Sturtevant, WIS/N 17274265N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470N510LPSouthern Cross Aviation LLC · Parker, AZBuilt 2003 · S/N 172S9510N510NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2010 · S/N 172S10952N51109Dickhaut Olivia N · North Palm Beach, FLS/N 17274268N5110ADickens Dennis D · Noble, OKBuilt 1955 · S/N 28110N5113FVtf LLC · Winter Haven, FLBuilt 1965 · S/N 17252762N5113KParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1979 · S/N 17272455N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974N5114USilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1980 · S/N 172RG0243N5114ZMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10927N5115BWateractive43 LLC · Auburn, CAS/N 172S8987N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717N5115FSunrise Equipment Co · Canton, OHBuilt 1965 · S/N 17252776N51163Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10930N5116ABatch Bryan A · Spokane, WABuilt 1955 · S/N 28116N5116BQuantum Aviation LLC · Manchester, MDBuilt 2002 · S/N 172S9161N5116FMancuso Donald R · Weatherford, TXBuilt 1965 · S/N 17252783N5116JCarll Elizabeth M · Chicago, ILBuilt 1979 · S/N 17273707N51178Tussey Mountain Flying Club LLC · State College, PABuilt 1980 · S/N 17274274N5117ANorthwest Aircraft Maintenance LLC · Springdale, ARS/N 28117N5117EJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 17271719N5117QBush Thomas D Jr · Cypress, TXS/N 17261755N5118AQuinn Thomas P · Cherry Hill, NJBuilt 1955 · S/N 28118N511EZiese And Grieshaber Consulting LLC · Catawba, NCBuilt 1959 · S/N 47107N511EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12863N511GKAir Devices Company LLC · Alpena, MIBuilt 1978 · S/N 17270431N511MPN511mp LLC · Wilmington, DEBuilt 1980 · S/N 17274472N511NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2008 · S/N 172S10762N511PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264226N51202Wolter David · Fortuna, NDS/N 17274278N51204Purdue Aviation LLC · West Lafayette, INS/N 17274279N5120ALane Christopher A · Lakeland, GABuilt 1955 · S/N 28120N5120FUnited States Air Force · Jacksonville, FLBuilt 1965 · S/N 17252811N51213Shelley Aaron J · Corbin, KYBuilt 1974 · S/N 17264227N5121QClift William R II · Princeton, KYBuilt 1973 · S/N 17261756N51221Provost Kevin H · North Swanzey, NHS/N 17264228N51222Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1980 · S/N 17274283N5122ADopson Joel A · Ooltewah, TNS/N 28122N5122FRay Richard H · Franklin, GABuilt 1965 · S/N 17252825N5122R1st Clev-Mar LLC · Lakeview, ARBuilt 1974 · S/N 17263340N5122UChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10911N51236Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274286N51238Flying G Aviation Inc · Drayton, NDBuilt 1980 · S/N 17274287N5123AGrabenstein Walter L DBA · Bradenton, FLFirst renewal noticeBuilt 1955 · S/N 28123N5123EMiller Kenneth Allen · Riverhead, NYBuilt 1978 · S/N 17271722
Back to AD 90-06-03 R1