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.

N6701TAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1980 · S/N ME-285N6701VHub City Aviation Academy LLC · Lubbock, TXBuilt 1979 · S/N ME-297N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032N6702DMcwilliams Christopher S · Atlanta, GABuilt 1979 · S/N M-2231N6702HGoetz Terry L · Defiance, IABuilt 1975 · S/N 17265545N6702JWaldron Michelle M · Saranac, NYBuilt 1968 · S/N 28-24397N6702NRoman Jose Ernesto · Guaynabo, PRBuilt 1968 · S/N 680080N6702UKruse Benjamin · Phoenix, AZS/N 2434N6702XFlight Time Builders Inc · Memphis, TNBuilt 1981 · S/N ME-287N6703SSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 3621N6704DScaled Composites LLC · Mojave, CABuilt 1980 · S/N ME-325N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052N6704JRussell John T · Southaven, MSBuilt 1979 · S/N M-2238N6704LSoflo Aviation LLC · Oakland Park, FLBuilt 1979 · S/N M-2240N6704NBethel William C · Murray, KYBuilt 1968 · S/N 680081N6705JDuncan William E · Troy, IDBuilt 1968 · S/N 28-24400N6705NGerback Andrew · East Canton, OHBuilt 1968 · S/N 680042N67065Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1957 · S/N 1023N6706BZvacek Dennis E Trustee · Tulsa, OKBuilt 1956 · S/N 22-4038N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547N6706NKorn Richard Mark · Lexington Park, MDBuilt 1968 · S/N 680082N6706YSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N ME-299N6707DMines Keith A · White Cloud, MIBuilt 1958 · S/N 2187N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548N6707MLouis & Clark Aviation LLC · Fort Myers, FLBuilt 1979 · S/N WA-48N6707NRegistered aircraftBuilt 1968 · S/N 680043N6707XGromack Stephen · Bloomfield, NMBuilt 1980 · S/N M-2241N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243N6708PWest Robert S · Gravois Mills, MOBuilt 1960 · S/N 24-1834N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245N6708UBlaedow Kyle R · Leesville, LAS/N 2440N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835N670BBeck Mark A · Fort Wayne, INBuilt 2007 · S/N 60176N670LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881680N670MAVan Anda Aviation LLC · Apopka, FLBuilt 1999 · S/N 17280728N670MLQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N MC-65N670RVSokoloski Gregory · Magnolia, TXBuilt 2006 · S/N 90670N670SBDanles Enterprises LLC · Solvang, CABuilt 2001 · S/N 23806N670SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881436N670UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020168N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246N6710NJohnson Kenneth W · Pine Bluff, ARBuilt 1968 · S/N 680084N6710UMonroe Flying Club Inc · Glen Carbon, ILBuilt 1963 · S/N 2442N6710ZHeatwole Oren · Dayton, VABuilt 2017 · S/N 82060
Back to AD 90-04-06 R1