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.

N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690286N75049Christie Brian L · Irvine, CABuilt 1976 · S/N 28-7690287N7504FDerr Michael K · Maitland, MOBuilt 1969 · S/N 715N7504HSmokovitz Tyler · Fenton, MIBuilt 1946 · S/N 12-365N7504SAirczar LLC DBA · Corpus Christi, TXBuilt 1987 · S/N S1260N7504VImage Craft LLC · Phoenix, AZBuilt 1975 · S/N 177RG0803N7504WThompson Reese F · Lake Stevens, WABuilt 1965 · S/N 28-2905N75050Delaware State University · Dover, DEBuilt 1976 · S/N 28R-7635262N75055Registered aircraftBuilt 1976 · S/N 28-7625196N75056Warwick Kenneth Robert · Estill Springs, TNBuilt 1976 · S/N 28-7615242N75057Gunter Jerry L Sr · Huntersville, NCBuilt 1976 · S/N 28-7615243N75058Russell K C · Lindsay, CABuilt 1976 · S/N 28-7615244N75059Markiewicz Mark J · Kokomo, INBuilt 1976 · S/N 28-7690289N7505BSilver Wings Inc Trustee · Wilmington, DEBuilt 1985 · S/N S1205N7505DCronan Joseph M · Santa Maria, CABuilt 1957 · S/N 22-5232N7505FIpme Management Corp · Jefferson, GABuilt 1969 · S/N 716N7505RMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 28-22061N7505VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 177RG0804N75068Kinzie Industries Inc · Erie, COExpired dealerBuilt 1988 · S/N S1323N7506FOklahoma Airmen Flying Club Inc · Jenks, OKBuilt 1969 · S/N 717N7506KHaugh Darin · Fairbanks, AKBuilt 1950 · S/N 18-226N7506NMeshoppen Air LLC · Tunkhannock, PABuilt 1988 · S/N S1305N7506RGleason Joseph G · Gainesville, FLBuilt 1966 · S/N 28-22062N75070Mansfield Heliflight Inc · Milton, VTS/N S1404N75078Gibson Elizabeth Grace · Hamilton, NJBuilt 1976 · S/N 28-7615246N7507CBlair & Son Inc · Fleetwood, PABuilt 1988 · S/N S1349N7507FThomson Mary Ellen · East Berlin, PABuilt 1969 · S/N 718N7507GEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3240N7507MWeststar Ventures LLC · Cannon Falls, MNBuilt 1989 · S/N S1365N7507NKinzie Hon · Anchorage, AKBuilt 2002 · S/N 3321N7507RPanko Douglas A · Minooka, ILFirst renewal noticeBuilt 1966 · S/N 28-22063N7507USierra Sky Aviation LLC · Kalispell, MTBuilt 1989 · S/N S1393N75080Dix Jeffrey G · Wausau, WIBuilt 1976 · S/N 28-7615247N75082Up And Away Aviation LLC · Poughkeepsie, NYBuilt 1976 · S/N 28-7690290N75084Wadas Burton J · Hudson, NHBuilt 1976 · S/N 28-7690292N7508HSons Aviation LLC · Moody, ALBuilt 1992 · S/N S1628N7508KRegistered aircraftBuilt 1950 · S/N 18-221N7508LBruegger Shannon B · Lance Creek, WYBuilt 1989 · S/N S1417N7508RTaylor Devan A · Overland Park, KSBuilt 1966 · S/N 28-22065N75093Turner Barry D II · Mccook, NEBuilt 1976 · S/N 28-7625198N75095Smith David Ross · Greensboro, NCBuilt 1976 · S/N 28-7615249N7509DPiggott Philip W · Peru, INBuilt 1957 · S/N 22-5236N7509MFerry Douglas W · Santee, CABuilt 1959 · S/N 55809N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710N750CZBinder Douglas B · Ithaca, NYS/N 750N750DAParkhill Lawrence · Ojai, CAS/N C75-10166N750DS5 Pm Inc · Nampa, IDBuilt 2002 · S/N 1001N750FYShuck Matthew M · Merrill, ORBuilt 2012 · S/N 75-8309N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947N750KOgk Aviation LLC · Mandan, NDBuilt 1974 · S/N 18-7409134
Back to AD 90-04-06 R1