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.

N827FJMiller Andrew W · Palmer, AKBuilt 2022 · S/N 92010N827GBJohnson Douglas C · North Grafton, MABuilt 1998 · S/N 22394N827GLEtchart Joseph O · Glasgow, MTBuilt 1978 · S/N 0827N827GSFosha Kathryn · Tehachapi, CAS/N 23646N827JHEisenmenger James P Trustee · Yankton, SDBuilt 1996 · S/N 2438N827JPHuls James J · Madison, SDBuilt 2002 · S/N 80920N827KSPlanelease LLC · Venice, CABuilt 1999 · S/N 17280793N827MAPs N827ma LLC · Green Bay, WIBuilt 2001 · S/N 17281015N827NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881289N827PAkin Thomas A · Visalia, CABuilt 2005 · S/N 82118N827PMMagnuson Peter C · Ocala, FLBuilt 2020 · S/N DMO 272N827VPClik Services LLC · Forestdale, MABuilt 1959 · S/N 55840N827WTCsu Aviation LLC · Plainfield, INBuilt 1996 · S/N 1222-96N8280NEllis Clifford J · Murray, KYBuilt 1969 · S/N 28-25496N8280WGarbin Kurt A · Steamboat Springs, COBuilt 1965 · S/N 28-2437N8281CThomas Ken C · Fairbanks, AKBuilt 1954 · S/N 18-3689N8281EAir Plains Services Corp · Wellington, KSBuilt 1979 · S/N 17272168N8281GWidtfeldt John R · Auburn, PABuilt 1971 · S/N 177RG0181N8281JJudy Gregory K · Hudson Oaks, TXBuilt 1979 · S/N VAC-127-79N8281NTan Dexter E · Dallas, TXS/N 28-25497N8281WNeisen Brandon L · Fowler, ILBuilt 1965 · S/N 28-2438N8282JHoover Michael B · Ridgeland, WIBuilt 1979 · S/N VAC-128-79N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071N8283JFurey Gale J · Bedford, NHBuilt 1979 · S/N VAC-129-79N8283NRuth Joyce Aviation LLC · Henderson, TXBuilt 1969 · S/N 28-25499N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064N8284JCrouch Scott M · Steamboat Springs, COBuilt 1979 · S/N VAC-130-79N8284NHolland Alan L · Houston, TXBuilt 1969 · S/N 28-25501N8284WCaldwell Darrel R · Panama City Beach, FLBuilt 1965 · S/N 28-2443N82859Schoeler George A · Ocala, FLBuilt 1980 · S/N 28R-8118018N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171N8285WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2446N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503N8286RHuhnke John F · Newburgh, INBuilt 1999 · S/N 103N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422N8287Holloway Earnie G · Bonner Springs, KSBuilt 1972 · S/N 5231931N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048N8287JBurnett Stephen B · Granby, MOBuilt 1979 · S/N VAC-133-79N8287NBetik Patrick G · Grapevine, TXS/N 28-25504N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020N8288CRood James D · Winston, NMBuilt 1955 · S/N 18-4113
Back to AD 90-04-06 R1