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.

N6988ARegistered aircraftBuilt 1956 · S/N 29088N6988XPaul Aviation LLC · Wasco, CAS/N 17247888N698JABon Bon Aviation LLC · Daly City, CABuilt 2008 · S/N 172S10698N698SPFoothill Aircraaft Sales & Service Inc · Upland, CABuilt 2000 · S/N 172S8639N6991HRhinelander Flying Service Inc · Palmetto, FLBuilt 1975 · S/N 17265683N6992XBurleson James R · Snyder, TXBuilt 1960 · S/N 17247892N6993AHurta Jennifer · Cypress, TXBuilt 1956 · S/N 29093N6994AMeador George D · Austin, TXBuilt 1956 · S/N 29094N6994XVossler Kevin D · Bismarck, NDBuilt 1960 · S/N 17247894N6995XWarmkessel James R · Felton, CABuilt 1960 · S/N 17247895N6996HWeirich Gayle M · Rockford, MIBuilt 1975 · S/N 17265685N6997AAirpower Aviation Resources Inc · Newbury Park, CABuilt 1956 · S/N 29097N6998APincheon Reginald · La Vergne, TNBuilt 1956 · S/N 29098N6999AHartzler Jeffery A · Rittman, OHBuilt 1956 · S/N 29099N6999RWorswick Dwight D · Yuba City, CAS/N 17251549N699LPFrg III Inc DBA · Lincoln Park, NJBuilt 1999 · S/N 172S8275N69AMMargitan Allan R · Nine Mile Falls, WABuilt 1958 · S/N 36569N69BNSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 17261945N69MGArizona Active Air LLC · Yuma, AZBuilt 1962 · S/N 17249282N69ZBSpringfield Flying Service LLC · Columbia, CABuilt 1958 · S/N 36585N6ABCenterline Holdings Inc · Camden, DEBuilt 1969 · S/N 17258164N6HNTalbott Philip A · Galena, OHBuilt 1971 · S/N 172-60326N6JYYoung John B · Panacea, FLBuilt 1956 · S/N 28217N6MBSierra Whiskey Aircraft LLC · Oakland, CABuilt 1968 · S/N 17257279N6TVTravelaire Service Inc · Wilmington, DES/N 17275278N6ZPAmerican Patrols Inc · Midland, TXBuilt 1980 · S/N 17274020N70000Carson Mark L Trustee · Northfield, MNBuilt 1976 · S/N 17267178N70004Gbl Aviation LLC · Laurel, MSBuilt 1976 · S/N 17267179N7000AHaley Michael R · Hobbs, NMFirst renewal noticeBuilt 1956 · S/N 29100N7000TCarter Jared · Lebanon, TNBuilt 1959 · S/N 46600N7001ALkp Aviation LLC · Montgomery, INS/N 29101N7002AAustin James M · Fort Worth, TXBuilt 1956 · S/N 29102N70032Alpha Wings Inc · Willoughby, OHBuilt 1976 · S/N 17267180N7003AHuang Sophie M · Newcastle, WABuilt 1956 · S/N 29103N70046Zane Newton F · Rllng Hls Est, CAS/N 17267183N7004AMitchell Mark A · Pittsford, NYBuilt 1956 · S/N 29104N7004GMcgreen John R · Albany, NYBuilt 1969 · S/N 17258704N70052Hastings Heidi · Wasilla, AKBuilt 1976 · S/N 17267185N7005AStansell Clayton H · Los Lunas, NMBuilt 1956 · S/N 29105N7005GHamilton Peter D · Bear, DEBuilt 1969 · S/N 17258705N7005QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1971 · S/N 17260305N7005TSmith Roy B · Newland, NCBuilt 1959 · S/N 46605N7006AFletcher John G · Diamondhead, MSBuilt 1956 · S/N 29106N7006QToney Edward L · Hampton, GABuilt 1971 · S/N 17260306N7006TFraas Stephan H · Meriden, CTBuilt 1959 · S/N 46606N7008AMitchell Shawn J · Red Bluff, CAS/N 29108N7008TDelaney Patrick James · Marion, TXS/N 46608N70095Eastern Kentucky University · Richmond, KYBuilt 1976 · S/N 17267192N7009QJoiner Legacy Enterprises LLC · Joliet, MTS/N 17260309N7009TCrigler Christopher E · Warrenton, VABuilt 1959 · S/N 46609
Back to AD 90-06-03 R1