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.

N66710Big Bend Community College · Moses Lake, WABuilt 1983 · S/N M-2387N6671ABurke John E · Spring, TXBuilt 1956 · S/N 28771N6671JRotor And Wing LLC · Tioga, NDBuilt 1968 · S/N 28-24357N6671PLunn Frank Paul III · Chatham, NHBuilt 1974 · S/N 17264371N6671RSmith Edward J · Sweet Valley, PABuilt 1964 · S/N 2778N6671UWizard Ventures Inc · Wilmington, DEBuilt 1963 · S/N 2398N6671WSessions Max R · Moody, ALS/N 28-21282N66720Erickson Kirk E · Warroad, MNBuilt 1940 · S/N 5588N6672AVandenbark Cody M · Troy, IDBuilt 1956 · S/N 28772N6672HDavenport Thomas C · Buchanan Dam, TXS/N 17265531N6673JMoody Edward L Jr · Candler, NCBuilt 1968 · S/N 28-24359N6673WCk Nickels Inc · Muleshoe, TXBuilt 1965 · S/N 28-20780N66740Wasik Richard C · Frankston, TXS/N 75-2360N6674LPurkinje Ltd LLC · Wilmington, DEBuilt 1970 · S/N 437N6674RLechner Mark J · Sault Sainte Marie, MIBuilt 1964 · S/N 2781N6675JReece Aviation LLC · North Clarendon, VTBuilt 1968 · S/N 28-24362N6676JRozof Chester F · Fort Myers, FLBuilt 1968 · S/N 28-24363N6676RJackson Michael W · Bedford, TXBuilt 1964 · S/N 2866N6676WWorkman Industries Inc · Durant, IABuilt 1965 · S/N 28-20783N6677HPeterson Robert E · Richland, WABuilt 1975 · S/N 17265533N6677WOsgood Darrell F · Watervliet, MIBuilt 1965 · S/N 28-20784N6678FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715175N6678JWiener Ronald K · Tucson, AZBuilt 1968 · S/N 28-24365N6678WMadison Andrew J · Inver Grove, MNS/N 28-20786N6679UKimbrough Edward W · Houston, TXS/N 2513N667ABlaschka Michael T · Medford, ORFirst renewal noticeBuilt 1951 · S/N 22-69N667BAAmendala Brian R · Hillsboro, ORS/N R669N667CRKnieling Gene A · Rush Center, KSBuilt 2000 · S/N 25317N667LBChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843932N667LDLeading Edge Aviation LLC · Manchester, MOS/N 1355N667QTevik Michael A · Provo, UTBuilt 1959 · S/N TD-260N667SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881435N667SPHindi David · Cupertino, CABuilt 1998 · S/N 172S8070N667TCT J Aviation LLC · Kennesaw, GABuilt 1988 · S/N 960N6680EPrax Philip · Fairbanks, AKBuilt 1959 · S/N 56180N6680JElliott Bryn · Blue Point, NYS/N 28-24368N6680RWestlake Mark A · Jewett, OHS/N 423N6681UGriffin Josh R · Minot, NDS/N 2408N6681XSky Harbor Aviation LLC · Powder Springs, GABuilt 1983 · S/N M-2388N6682LDeyo Kenneth F · Thomaston, CTBuilt 1970 · S/N 445N6682RCavazos Jose Luis Jr · Houston, TXBuilt 1964 · S/N 2867N66836Wolgemuth Jim · Anchorage, AKS/N 18-7709039N6683UReisner Kenneth D · Lecompte, LAS/N 2410N66842Gelvin Stanley M · Central, AKBuilt 1977 · S/N 18-7709140N6684KMaslar Joseph P · Houston, TXBuilt 1946 · S/N 967N6684RRoberts Alec · Boulder, COS/N 427N6684UFowler Kenneth G · Newport, TNBuilt 1976 · S/N 24-0036N6684WWaltman Richard Dean · Moses Lake, WAFirst renewal noticeBuilt 1965 · S/N 28-20790N6685UMccroskey Wesley D · Kingston, TNBuilt 1963 · S/N 2412N6685WZulueta David · Louisville, GAS/N 28-20791
Back to AD 90-04-06 R1