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.

N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051N9023LLammers David T · Bonney Lake, WABuilt 1970 · S/N 246-70N9023MBrandis Robert J · Taylorville, ILS/N 2020N9024Simply Living LLC · Fort Myers, FLBuilt 1928 · S/N 826N90249Helicopteracademy.Com LLC · Rehoboth Beach, DES/N 0039N9024LVine Grove Airport Inc · Vine Grove, KYBuilt 1970 · S/N 758-70N9025Ocean Air Inc · Eugene, ORBuilt 1958 · S/N 2292N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053N9025LMcmillan Custom Service Inc · Ulmer, SCBuilt 1970 · S/N 759-70N9026DCuthbertson Steven M · Van Alstyne, TXBuilt 1958 · S/N 22-6163N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054N90270Dunn Larry W · Anderson, SCBuilt 1966 · S/N 66-18283N90271Gartman Jerald B · Morehead City, NCBuilt 1965 · S/N 65-18261N9027FErickson Jon D · Atwater, MNBuilt 1976 · S/N 28-7715299N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055N90293Grasshopper Aviation Inc · Geneseo, NYBuilt 1981 · S/N 690N9029LMarracino Services LLC · Deland, FLBuilt 1970 · S/N 258-70N9029YJohnson Scott W · Saline, MIBuilt 1970 · S/N 18-8905N902ALBy Tor Aviation LLC · Phoenix, AZBuilt 2014 · S/N 65-7478N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902CWhite Edwin W · Eagle River, AKBuilt 2001 · S/N 2162N902CCVan Flve Klub Inc · Holt, MNS/N 9902CCN902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174N902GRWright Allan M · Los Gatos, CABuilt 2002 · S/N 2411N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530N902SAWild Wings Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N SH001N902SCCampbell Steven · Tipp City, OHBuilt 2021 · S/N 067N90309Roe David N · Santa Fe, NMBuilt 2007 · S/N 81049N9030FDesouza Ferdinand E · El Prado, NMS/N 454N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059N9031LSanderlin Doulgas C · Wasilla, AKBuilt 1970 · S/N 253-70N9032LJohnson Robert W · Buffalo, SDBuilt 1970 · S/N 259-70N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062N9033LBickmore David L · Bay City, MIBuilt 1970 · S/N 260-70N90343Kay R Steven · Riverside, CABuilt 1979 · S/N DAL 78R1N90347R & S Aircraft LLC · Wilmington, DEBuilt 1946 · S/N 361N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184N9036LWhitmer Charles W · Fairbanks, AKBuilt 1970 · S/N 264-70N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N90371Jackson Thomas M · Mckinney, TXS/N 385N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067
Back to AD 90-04-06 R1