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.

N5555WLemieux Patrick · San Luis Obispo, CABuilt 1962 · S/N 28-647N5555ZKramer Brian J · Seattle, WABuilt 1962 · S/N 22-9348N55563Sanchez Alejandro Arturo · El Paso, TXBuilt 1973 · S/N 28-7325433N55564Moore Ryan J · Corvallis, ORBuilt 1973 · S/N 28-7305414N55565Brickweg Kurt J · Cincinnati, OHBuilt 1973 · S/N 28-7305415N55566Speck G Dan · Roaring Spring, PABuilt 1973 · S/N 28R-7335252N5556SSmith Steven D · Sanger, TXBuilt 2023 · S/N 24078N5556UCynthiana Flying Group Corp · Cynthiana, KYBuilt 1969 · S/N 28-26282N55570Johnson Lawrence F · Colville, WAFirst renewal noticeBuilt 1941 · S/N 75-1563N55575Bemis Kenneth L Trustee · Brawley, CABuilt 1946 · S/N 75-1824N55578Gardiner Merrill L · Traverse City, MIBuilt 1973 · S/N 28-7325435N5557JSmtm Holdings Inc · Wilmington, DEBuilt 1991 · S/N 1326N55585Kankakee Area Flying Group LLC · Gilman, ILBuilt 1973 · S/N 28-7305418N5558FConner Brad S · Waynesville, OHBuilt 1968 · S/N 28-24898N5558WPatterson Troy V · Arlington, TXS/N 28-650N55593Flying Life LLC · Fuquay Varina, NCBuilt 1973 · S/N 28-7305400N55596Outdoor Products Of Louisiana LLC · Heflin, LAS/N 28-7325439N55597Arndt Douglas E · Marion, WIBuilt 1973 · S/N 28-7305421N55598Smith Gregory E · Manila, ARS/N 28-7305422N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899N5559MBertelson Chester J · Modesto, CABuilt 1967 · S/N 096N555AEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1962 · S/N 1001N555AKBusy Bee Helicopter LLC · Paulding, OHBuilt 1993 · S/N 535N555AWRamakrishna Murali DBA · Malden, MABuilt 2010 · S/N 536-2010N555AXWalsh David · North Platte, NEBuilt 2001 · S/N 9927CCN555AZN555az LLC · Herndon, VABuilt 1969 · S/N 28-26585N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254N555BJGypsy Aviation LLC · Newnan, GAS/N 182N555CAFigueiredo William A · Riverside, CABuilt 1974 · S/N 28-7415139N555CCDavis Donel · Hollis, NYBuilt 1974 · S/N M-1589N555CVAviation Paradise LLC · Homestead, FLBuilt 1976 · S/N 17267112N555CWWolff Christine A Trustee · Aurora, COBuilt 1978 · S/N 1172N555DScotts Helicopter Services Inc · Le Sueur, MNBuilt 1956 · S/N 1478N555DCAmoroso Ricardo C · Powder Springs, GABuilt 1959 · S/N 23-1780N555DDBnc Aviation LLC · Georgetown, TXBuilt 1977 · S/N 177RG1122N555DKHorst Sheldon L · Columbia, PABuilt 1988 · S/N HOLMAN 0001N555DNChapman Larry D · Avoca, IABuilt 2000 · S/N 22276N555DYCaptain'S Quarters Marina & Storage Inc · Johnson Lake, NEBuilt 1966 · S/N 670055N555EDPoteet-Schwartz Kim L · Albuquerque, NMS/N 24-0684N555EEKielich Darryl C · Knights Landing, CABuilt 1968 · S/N 28-24888N555FBMunson Seth · Phoenix, AZBuilt 2007 · S/N 70021N555FJAir Kanga LLC · Wilmington, DEBuilt 2008 · S/N 80807N555FLD&J Aviation LLC · Apopka, FLBuilt 1971 · S/N 28-7125394N555FNFlying Neutrons LLC · Lebanon, OHBuilt 2001 · S/N 17280999N555GBGreen Chad W · Wasilla, AKS/N 18-6379N555GCSasakwa LLC · Pittsfield, MABuilt 1967 · S/N 670508N555HAYasko Gary R · Gallipolis, OHBuilt 1978 · S/N 28-7916125N555HEDetert Bradley · Valparaiso, INBuilt 1999 · S/N 848-99N555HFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 4496176
Back to AD 90-04-06 R1