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.

N576FLRocky Top Corp · Erin, TNBuilt 1971 · S/N 28-7125425N576KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843937N576PAClear Skies LLC · Whitehall, PABuilt 1975 · S/N 28-7525331N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501N5770HBellino Dominic P · Florence, COBuilt 1949 · S/N 16-386N5770QJohnson Darryl · Fowler, COBuilt 1965 · S/N 3087N5770VAkins Terral S · Grain Valley, MOBuilt 1966 · S/N MA-25N5770WGallo Danny P · Nashotah, WIBuilt 1964 · S/N 28-1578N5771DEllison Stephen · Anchorage, AKBuilt 1956 · S/N 18-5273N5771HHill Bruce T · Ramona, CABuilt 2014 · S/N 91894N5771QLuchterhand Charles · Salem, ORS/N 744N5771VLow & Slow Aviation LLC · Westminster, COBuilt 1966 · S/N MA-22N5771WCrumpton Bradley N · Caddo Mills, TXBuilt 1964 · S/N 28-1579N5771ZDavenport Brad E · Eagle River, AKBuilt 1963 · S/N 22-9613N5772DLong Randy B · Coleman, TXBuilt 1956 · S/N 18-5274N5772QTweten Gary L · Glasgow, MTS/N 3088N5772UBernstein Matthew D · North Charleston, SCBuilt 1970 · S/N 28-26596N5772VSouthwest Truck Parts Inc · Pratt, KSS/N MA-24N5772WBallard Gary H · Soddy Daisy, TNBuilt 1964 · S/N 28-1580N5773EOppegard Nicholas · Eagle River, AKS/N 17273N5773HSchneider Beth A · Midway, UTBuilt 1949 · S/N 16-384N5773MHulslander Taylor · North Pole, AKBuilt 1975 · S/N 18-7509082N5773QGunnerson Spencer · Murfreesboro, TNBuilt 1965 · S/N 745N5773UNelson Francis A · Winchester, VABuilt 1970 · S/N 28-26597N5774HPerron Ted J · White Bear Lake, MNFirst renewal noticeBuilt 1949 · S/N 16-385N5774LHickman Robert D · Mobile, ALS/N AA1-0174N5774ZLiming Danny O · Andrews, TXS/N 22-9610N5775EGates Rebecca S · GeorgetownNon-citizen corporation, flight hours not reportedS/N 17275N5775QSinger David · Vandalia, OHBuilt 1965 · S/N 746N5775UBravo Tango Aviation · Spearfish, SDBuilt 1970 · S/N 28-26599N57761Air Giblinski LLC · Sedgwick, KSBuilt 1943 · S/N 75-4663N5776HMastre Joshua M · Soldotna, AKBuilt 1949 · S/N 16-389N5776LCollins Timothy · Northfield, MNBuilt 1969 · S/N AA1-0176N5776UBrainard Gary Keith · Olney, ILBuilt 1969 · S/N 28-26600N57777Thorsgard Keith A · Mcville, NDBuilt 1978 · S/N 18-7809094N5777LSessums David L · Seabrook, TXBuilt 1969 · S/N AA1-0177N5777UFossa Matthew A · Pensacola, FLBuilt 1969 · S/N 28-26601N5777VDe La Garza Jimmy · Granbury, TXBuilt 1966 · S/N MA-29N5777WMaschek Anothony Q · Killeen, TXBuilt 1964 · S/N 28-1585N57787Shoultys Shawn P · Denali Park, AKBuilt 1977 · S/N 18-7709131N5778QPars Avn Corp · Wilmington, DEBuilt 1965 · S/N 3091N5778VGlenn Larry D · Reynoldsburg, OHBuilt 1966 · S/N MA-37N5778ZWhelan Cynthia Vs · Seneca, SCBuilt 1963 · S/N 22-9623N57792Arizona Game & Fish Dept · Phoenix, AZBuilt 1977 · S/N 18-7709132N5779DAltenburg Scott J · Anchorage, AKBuilt 1956 · S/N 18-5295N5779FScheer Abraham · Milton, DEBuilt 1968 · S/N 28-25085N5779HKelly David L · Pendleton, ORBuilt 1949 · S/N 16-395N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N5779ZSvec Adolph R · Marengo, ILBuilt 1963 · S/N 22-9624N577CMEllison Ranching Co · Elko, NVBuilt 1977 · S/N 18-7709134
Back to AD 90-04-06 R1