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.

N55955Pierce Riley Deirdre · Chicago, ILBuilt 1973 · S/N 28-7325542N55958Rl Magneto LLC · Sacramento, CABuilt 1973 · S/N 28R-7335317N5595EV & E Sunset LLC · St George, UTBuilt 1978 · S/N 17271897N5595FByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28-24883N5595HHornby James C · Kaukauna, WIBuilt 1951 · S/N 20-659N5595PCassell Joseph · Singer, LABuilt 1959 · S/N 24-662N5595QLivezey Patrick · Lithia, FLBuilt 1965 · S/N 2988N55960Gallagher Sean · Cave Creek, AZBuilt 1973 · S/N 28R-7335318N55965Greene County Flying Club · Waynesburg, PABuilt 1973 · S/N 28-7305510N55967Hisman Gary L · Skagway, AKS/N 28-7305511N55968Tindle David W · Fennville, MIFirst renewal noticeS/N JC-1N5596UPine Aviation Inc · Sheridan, WYBuilt 1969 · S/N 28-26326N5596ZLamb Steve E · Big Bear City, CABuilt 1962 · S/N 22-9407N5597Quinn Michael P · Matthews, NCS/N BF-P478N55970Soaring Eagle Aviation LLC · Carmi, ILBuilt 1973 · S/N 34-7350266N55973Crase Nicole Trustee · Mansfield, OHBuilt 1973 · S/N 28-7325543N55975Pena Leonardo · The Colony, TXBuilt 1973 · S/N 28-7325545N55977Walker Benjamin M · Weatherford, TXBuilt 1973 · S/N 28-7305512N55979Acumen Aerotech LLC · Rogers, TXBuilt 1973 · S/N 28R-7335321N5597FDeardorff Karl R · San Luis Obispo, CABuilt 1968 · S/N 28-24853N5597HNicholson Robert Lyle · North Ogden, UTS/N 20-661N5597UFejor Inc · San Juan, PRBuilt 1969 · S/N 28-26327N5597WLathrop Christopher A · Palmyra, WIBuilt 1962 · S/N 28-733N55986Turner Jeffrey K · Gastonia, NCBuilt 1973 · S/N 28R-7335322N55988Murawski Rene · Clarkston, MIBuilt 1973 · S/N 28-7325549N5598FKeran Gary R · New Holstein, WIBuilt 1976 · S/N 28-7725064N5598UHilton Colby W · Amarillo, TXBuilt 1969 · S/N 28-26328N5598WBall Dontel J · Tacoma, WAS/N 28-734N5598ZEkstrom David L · Bemidji, MNBuilt 1962 · S/N 22-9409N55990Registered aircraftN-number assigned, not yet registeredS/N 28R-7335323N55996Mcfarlane Randall C · Loudonville, NYBuilt 1973 · S/N 28R-7335325N5599BMccain David O · Ashville, ALBuilt 1980 · S/N 0828N5599QFerraro Christopher · Croydon, PABuilt 1965 · S/N 2990N5599WPhoenix Aviation LLC · Claremore, OKBuilt 1962 · S/N 28-736N559DDRobinson Helicopter Co Inc · Torrance, CAS/N 3299N559ESeitan Eduard · Chicago, ILS/N 28-3248N559FLSandlak David J · Zephyrhills, FLBuilt 1971 · S/N 28-7125400N559MKBadawi Aviation LLC · Orlando, FLBuilt 1979 · S/N ME170N559PDCrocker Donald E · Eagle, IDBuilt 2015 · S/N 91817N559PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842096N559RVBrady Norman M · Port Orange, FLBuilt 2009 · S/N 90978N559SGQualitair LLC Trustee · MichelstadtBuilt 1976 · S/N 384N559SP1.2 Gpa LLC · Rapid City, SDBuilt 2000 · S/N 172S8410N559WKleiss Norman J · Cloverdale, INBuilt 2006 · S/N 0001N55ADSchrage Rodney L · Steamboat Springs, COBuilt 1977 · S/N 1006N55AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 30-804N55AHHancock James T · South Saint Paul, MNBuilt 1978 · S/N 5555N55AJJudge Andrew L · Pinecrest, FLBuilt 1998 · S/N DMO 413N55AMAdams Floyd R · Sebring, FLBuilt 1966 · S/N 362N55ATAugust Aero LLC · Kalispell, MTS/N 001
Back to AD 90-04-06 R1