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.

N676CHTake Off Aviation Services LLC · Rockledge, FLBuilt 1976 · S/N 17266905N676DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280774N676ECCastle Joseph E · Marietta, OHBuilt 1997 · S/N 2163N676FLEdwards William J · Big Rapids, MIBuilt 1971 · S/N 28-7125605N676HWinterbottom Eric A · Beavercrk Twp, OHBuilt 1986 · S/N 676N676MMButler Nathaniel J · West Fargo, NDBuilt 2006 · S/N 2843631N676NLoftus Timothy P · Mclean, VABuilt 1968 · S/N 680032N676QKeil Urban G · The Villages, FLBuilt 2002 · S/N 4213N676SECircle K Aircraft Leasing LLC · Houston, TXBuilt 2010 · S/N 2843676N676TFAeon62 Holdings LLC · Plano, TXBuilt 2022 · S/N 2881554N676WLeymaster Michael J · Westerville, OHBuilt 1977 · S/N AA5B0676N676YMarvin James · La Verkin, UTBuilt 2008 · S/N 3016N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974N6770NGrant William S · Azle, TXBuilt 1968 · S/N 680090N6770VDobalian Vaughn E · Jacksonville Beach, FLBuilt 1970 · S/N 700060N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976N6771FDecruz Enterprises LLC · Hattiesburg, MSBuilt 1976 · S/N 28-7715178N6771VBrice Michael · Dickinson, NDBuilt 1970 · S/N 700078N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983N6772JMaljanion Mark D · Upton, MABuilt 1968 · S/N 28-24497N6772NHapp Michael E · Valley Center, KSBuilt 1968 · S/N 680083N6772WKolb Lowell E · Rapid City, SDBuilt 1965 · S/N 28-20899N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986N6773JTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1968 · S/N 28-24498N6773NMills David J · Combine, TXBuilt 1968 · S/N 680091N6773VSouthern Mooney Inc · Wilmington, DES/N 700079N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992N6774BLegacy Aviation And Sales LLC · Ririe, IDBuilt 1956 · S/N 18-5007N6774DSouthern Cross Aviation · Wilmington, DES/N 2450N6774UFair Weather Holdings LLC · Centennial, COBuilt 1963 · S/N 2496N6774W10-4 Aviation LLC · Waco, TXBuilt 1965 · S/N 28-20901N67753Southwinds Export Inc · Kissimmee, FLS/N 15281998N6775BOcean Aerial Ads Inc · Berlin, MDBuilt 1956 · S/N 18-5008N6775FPittsburgh Flying Club Inc · Greensburg, PABuilt 1976 · S/N 28-7790163N6775NAirvantage Global LLC · Lake Worth, FLBuilt 1968 · S/N 680085N67760Farquar Leasing Inc · North Bend, ORBuilt 1978 · S/N 15282002N67765Guilbeau Austin K · Miami, FLS/N 15282005N6776DMilam Inc · Trussville, ALBuilt 1959 · S/N 2439N6776JLanier Bradley N · Asheboro, NCBuilt 1968 · S/N 28-24501N6776NClark Jeff N · Arab, ALBuilt 1968 · S/N 680092N6776UParmer Jeffrey C · Redondo Beach, CABuilt 1963 · S/N 2498N67778Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282013N6777BJim Franklin Aviation Service Inc · Ruidoso, NMBuilt 1956 · S/N 18-5011N6777JSeven Seven Juliet LLC · Palmer, AKBuilt 1968 · S/N 28-24502N6777NStephens Mark A · Las Vegas, NVBuilt 1968 · S/N 680086N6777TNeff Tj · Novato, CAS/N 17701049N6777ULongmont Mooney · Longmont, CORevoked, canceledBuilt 1963 · S/N 2499
Back to AD 90-04-06 R1