OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N24662Dumay Chad · O Fallon, MOBuilt 1973 · S/N MC-139N24663Stuber Paul A · Kansas City, MOS/N M-1425N24665Axiom Development & Consulting LLC · Atlanta, GAS/N MC-147N2466BFoecking James · Valley City, OHS/N 38-79A0073N2466EMarkham Dean F Jr · Greenville, NCBuilt 1978 · S/N 17271293N2466HRaven Girl LLC · Eagle River, AKS/N 18-7909187N2466MDonalds Flying Service Inc · Pantego, NCBuilt 1947 · S/N 12-1687N2466PGriffin Scott M · Springfield, OHBuilt 1955 · S/N 22-2841N24671Mustang Sally Aviation LLC · Signal Hill, CABuilt 2000 · S/N 17280925N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154N24676Goren Matthew B · Wilmette, ILBuilt 1972 · S/N M-1414N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576N2467MToelle Neill · Fairbanks, AKBuilt 1947 · S/N 12-1693N24686Larsen Rick D · Fond Du Lac, WIBuilt 1939 · S/N 3352N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294N2468HStallings Cameron G · Clovis, NMBuilt 1979 · S/N 18-7909191N2468JJh Investments LLC · Henderson, NVBuilt 1996 · S/N 24-3391N2468MSmith Steven Paul · Dammeron Valley, UTBuilt 2024 · S/N 8389N2468NSouth Texas Air Force LLC · Mission, TXBuilt 1979 · S/N 38-79A0858N2468TMackie Robbie L · Murfreesboro, TNBuilt 1971 · S/N 28-7225074N2468WGodwin Gerald · Orange, TXS/N 886-2001N2468ZPetersen Danny R · Exeter, NEBuilt 2018 · S/N 101N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N2469ABossola Raymond L · Suffolk, VAS/N 22-806N2469KPilot Ready LLC · Lime Springs, IABuilt 1979 · S/N 38-79A0654N2469PMccloud James C · Mokelumne Hill, CABuilt 1955 · S/N 22-2844N246ACMateski James C · Salmon, IDBuilt 1946 · S/N 12-684N246ADBialas Robert E II · Fort Worth, TXBuilt 1968 · S/N 28R-30423N246AJJensen Alan · Rock Springs, WYBuilt 2013 · S/N 82207N246AKGordon Andrew J · Paulding, OHBuilt 1999 · S/N 778N246AWSullivan Stanley D · South Jordan, UTS/N 72610N246BBTruman Nissley · Moberly, MOBuilt 1978 · S/N 24-0752N246CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2881002N246DAAdams Dennis M · Idaho Falls, IDBuilt 2021 · S/N 92131N246DTElswick Theodore · Fernley, NVS/N 71828N246EBeltz Roy C · Leesville, LABuilt 2026 · S/N 8960N246FC69px LLC · Suttons Bay, MIBuilt 2023 · S/N 246N246HNStamos Michael A · Buchanan Dam, TXBuilt 1986 · S/N 246N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535N246JSSullivan Jason W · North Pole, AKS/N 60201N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91N246LDHoppe Nicholas J · Big Lake, AKBuilt 1952 · S/N 18-1945N246MCChoules Michael K · Caldwell, IDBuilt 2010 · S/N 20247N246MMHildreth Shawn M · Osceola, IABuilt 1949 · S/N 59N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PMBesprozvanny Randy-Alexander R · San Marcos, CABuilt 1977 · S/N AA5B-0566N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005
Back to AD 90-04-06 R1