OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N3361BSmith Marcus H · Roxboro, NCS/N 22-2166N3361MTrinkle Chris · Heyburn, IDS/N 12-2240N3361TPew Aaron · Mesa, AZS/N 17700661N3362TMain Cynthia M · Richmond, TXFirst renewal noticeBuilt 1967 · S/N 17700662N33636Murphy George E · Robinson, ILBuilt 1975 · S/N 28-7525213N3363A7ac Club Inc · Clearwater, FLBuilt 1953 · S/N 22-1665N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518N3363MGlatt David · Bonita Springs, FLBuilt 1947 · S/N 12-2219N3363PDubois Aviation Inc · Chino, CABuilt 1958 · S/N 23-1320N33640Red Rooster Rentals LLC · Alto, GABuilt 1975 · S/N 28-7515349N33641Sutton Aircraft Salvage LLC · Palmer, AKS/N 28-7505161N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166N33648Sadiq Ahmed · Ontario, CABuilt 1975 · S/N 28-7525219N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519N3364THigh Mesa Aviation LLC · Naturita, COBuilt 1967 · S/N 17700664N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085N33655Gordon William S III · Aurora, COBuilt 1975 · S/N 28-7525220N33659North Central Flight Center LLC · Warwick, RIBuilt 1975 · S/N 28-7515351N3365BSmith James A · Lyle, WABuilt 1954 · S/N 22-2170N3366Sutton Aircraft Salvage LLC · Palmer, AKS/N 23-1919N33661Baker Justin Robert · Red Oak, TXBuilt 1975 · S/N 28-7505163N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171N33666Hancock Carl M · Glendale, AZBuilt 1975 · S/N 28-7505165N33667Aptum Aviation Inc · Hicksville, NYBuilt 1975 · S/N 28-7505166N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172N33672Nulton Enterprises LLC · Johnstown, PABuilt 1975 · S/N 28-7515298N33673Borregard Robert Stephen · San Jose, CAS/N 28-7515306N33674Beaulieu Marc R · Lewiston, MES/N 28-7525222N33676Bous Harry John · Cayce, SCBuilt 1975 · S/N 28-7525224N33679North Star Aviation Inc · Ulysses, KSFirst renewal noticeBuilt 1975 · S/N 28-7505167N3367PJackson Lee Roy Jr · Needville, TXBuilt 1958 · S/N 23-1324N3368Big Sky Aviation Inc · Wilmington, DEBuilt 1976 · S/N 100N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174N3368TTuley Richard L · Marietta, GARegistration revokedBuilt 1967 · S/N 17700668N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087N3368ZWatts Paul D · Weatherford, TXBuilt 1960 · S/N 22-7283N33691Wide Open Aviation LLC · Kalispell, MTBuilt 1975 · S/N 28-7525227N33692Horn Justin L · Hearne, TXBuilt 1975 · S/N 28-7505170N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181N3369ADoster Michael L · Nampa, IDBuilt 1953 · S/N 22-1667N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520N3369GCruz Miguel A · Fontana, CABuilt 1963 · S/N MA4-3N3369MCallen Jerry R Jr · Jerome, IDBuilt 1947 · S/N 12-2218N3369TBauer Charles · Graceville, MNS/N 17700669N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098N336BWAllen Scott L · Ogallala, NEBuilt 2001 · S/N 4352N336DBGustafson Gary E · Motley, MNBuilt 2005 · S/N 90805N336FPoskey Charles E · Alabaster, ALBuilt 1984 · S/N 679
Back to AD 90-04-06 R1