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.

N4813ZStanley Daniel P · Kiowa, KSS/N 22-8383N4814CKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275868N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366N4814LSingh Manjinder · Houston, TXS/N 28-4154N4814TRobertson Roland L · Meridian, IDBuilt 1972 · S/N 28-7205199N48156Perdue Ralph R Jr · Blacklick, OHBuilt 1979 · S/N 15283291N4815CSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1985 · S/N 17276453N4815FAir 2 Sea LLC · Martin, TNBuilt 1976 · S/N 28-7715069N4815LSt Julian Randall R · Botkins, OHBuilt 1967 · S/N 28-4155N4815TCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1972 · S/N 28-7205200N4815ZRoberson James · Stephenville, TXS/N 22-8385N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293N4816ASullivan Phillip M · Louisville, KYS/N 22-3969N4816LGodfrey John E · Greensboro, NCBuilt 1967 · S/N 28-4156N4816TBulldog Air LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235114N4816VCollins Lisa A · Lake Dallas, TXBuilt 1980 · S/N 172RG0388N4817BPriority One Insurance & Investments Inc · Hillsboro, NDBuilt 1979 · S/N 15283653N4817TJoly Paul A · Henderson, NVBuilt 1972 · S/N 28R-7235115N48187Nelson Lynn D · New Waverly, TXBuilt 1976 · S/N 26N4818ACampbell Allen G · Sault Sainte Marie, MIBuilt 1956 · S/N 22-3971N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311N4818LFischer Denise L · Lake View Terrace, CABuilt 1967 · S/N 28-4158N4818ZCornell Robert C · Lock Haven, PABuilt 1961 · S/N 22-8389N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367N4819TJacob Rolando V · Las Vegas, NVBuilt 1972 · S/N 28-7205201N4819ZWest Coast Air Design LLC · Granada Hills, CAS/N 22-8390N481AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843747N481ACVogel Lawrence O · Gig Harbor, WAS/N 1289-2000N481CHHatch Craig R · Lake City, FLBuilt 2007 · S/N 81481N481DMEdgewood Capital LLC · Joplin, MOBuilt 2001 · S/N 1307-2001N481EMClark Jeffrey V · Libertyville, ILBuilt 1996 · S/N 375-96N481GSSchmidt Grant S · Jamestown, NDBuilt 1973 · S/N 28-7325622N481JLWolfco Timber Services LLC · Lebanon, ORBuilt 2017 · S/N JA1607094N481MASlavens Timothy W · Howard City, MIBuilt 2003 · S/N 441-2003N481WSBoer John W · Okeechobee, FLBuilt 2013 · S/N 71940N481XCMarino Jerry C II · San Francisco, CABuilt 2012 · S/N 111N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369N4820FS&S Aviation Plus LLC · Greenville, ILBuilt 1976 · S/N 28-7790062N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368N4820LFick Paul R · Deansboro, NYBuilt 1967 · S/N 28-4160N4820ZPumford Thomas E Jr · Bannister, MIBuilt 1961 · S/N 22-8391N4821AMeyer James D · Cheney, KSBuilt 1956 · S/N 22-3974N4821FOestreich Klaus M · Needville, TXBuilt 1976 · S/N 28-7790063N4821LFlying Rocks LLC · Sparkill, NYBuilt 1967 · S/N 28-4162N48222N1705r Inc · Cobb, CAS/N 15283303N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304N4822ALybarger Michael L · Hot Springs, ARBuilt 1956 · S/N 22-3975
Back to AD 90-04-06 R1