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.

N477CHCsi Flight Services LLC · Mcminnville, ORBuilt 2004 · S/N 3729N477DCChildress David W · Coldwater, MSBuilt 2007 · S/N 70717N477DKPhilippi Ranches Inc · Hermiston, ORS/N 2160N477LLLima Lima LLC · Lander, WYBuilt 1968 · S/N 18-8755N477LMStampley Michael C · Mount Pleasant, SCBuilt 1965 · S/N 643N477MERegistration Pending · Webster, NYRegistration pendingBuilt 1969 · S/N 28R-35030N477PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881200N477PSSilver Patrick F · Toney, ALBuilt 2016 · S/N 91796N477RVVans Aircraft Inc · Aurora, ORBuilt 2004 · S/N 71702N477SPRegistration Pending · Leesburg, VARegistration pendingBuilt 2004 · S/N 71402N477TPaetzold Benjamin T · Fort Worth, TXBuilt 1967 · S/N 670274N477UCWeber Jennifer R · Bryan, TXBuilt 2013 · S/N 001N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253N4780APenn Flyers LLC · Greensburg, PABuilt 1956 · S/N 22-3931N4780ECarolinas Aviation LLC · North Myrtle Beach, SCBuilt 1978 · S/N 17271645N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228N4780LLemon Kyle · Santa Ynez, CABuilt 1967 · S/N 28-4115N47818Fischer Scott R · Spanaway, WABuilt 1977 · S/N 28-7816134N47819Candace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816136N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4781LPhillips James W · Lancaster, SCBuilt 1967 · S/N 28-4116N4781ZM Forden LLC · Pana, ILBuilt 1961 · S/N 22-8343N47820Vascular Wings LLC · Friendswood, TXBuilt 1977 · S/N 28-7890139N47824Morris-Reade Jeffrey M · Blaine, WABuilt 1977 · S/N 28-7890140N4782GSeguin Elliot · Rosamond, CABuilt 1968 · S/N 77N4782RSchulert Peter A · Lebanon, TNBuilt 1979 · S/N 172RG0030N4782TJordan Kevin · Brookline, NHBuilt 1972 · S/N 28-7225204N4783Haire Kenneth H · Star City, ARS/N 93N47833Rtt Aviation LLC · Columbus, NEBuilt 1977 · S/N 28-7816138N47835Paddock Andrew S · Ainsworth, NES/N 28-7816139N47837Kolek Kirk A · Marion, IABuilt 1977 · S/N 28-7816141N47839Ohara Daniel J · Naknek, AKS/N 28R-7837006N4783LSikka Dhruv · Lutz, FLBuilt 1967 · S/N 28-4118N4783PBush Robert Edward · Mead, WABuilt 1977 · S/N AA5B-0526N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891N4784EPeabody Jeffery L · Vinemont, ALBuilt 1978 · S/N 17271649N4784GShinn Steven M Allen · Larkspur, COBuilt 1973 · S/N 131N4784HKjeldgaard James K · Fremont, NEBuilt 1948 · S/N 11-737N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4784LDelta Sierra LLC · Naples, FLBuilt 1967 · S/N 28-4119N4784VFlying Acres Flyboys LLC · Milwaukee, WIBuilt 1944 · S/N 755434N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633N4785FSoaring Society Of Boulder Inc · Boulder, COBuilt 1962 · S/N 18-7906N4785LTranswestern Air Service Inc · Golden, COBuilt 1967 · S/N 28-4120N4785ZMeigs David C · Phoenix, AZS/N 22-8349N47868Heartland Airplanes LLC · Olathe, KSFirst renewal noticeS/N 28-7890147N47869N47869 LLC · Spanish Fork, UTBuilt 1977 · S/N 28R-7837008N4786ETu Erik S · Pasadena, CABuilt 1978 · S/N 17271651N4786LZayas Omar · Fontana, CABuilt 1967 · S/N 28-4122
Back to AD 90-04-06 R1