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.

N757HERussell Robert Q · Genoa City, WIBuilt 1977 · S/N 15279746N757HHA&R Aero LLC · Sacramento, CAS/N 15279749N757HMSchmitt Rudy · Brookshire, TXS/N 15279753N757HTParrish Aviation Flight Academy LLC · Southlake, TXS/N 15279759N757HVPropel Air LLC · Pottstown, PABuilt 1977 · S/N 15279761N757HXAppalachian Aviation LLC · Harrisonburg, VABuilt 1977 · S/N 15279763N757HYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279764N757JBBrilhart John G · Higbee, MOBuilt 2021 · S/N 74128N757JDSuburban Air Corp · Castro Valley, CABuilt 1977 · S/N 15279769N757JGJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279772N757JJJetstream Aeronautics LLC · San Antonio, TXBuilt 1977 · S/N 15279774N757JKMcdermotts Letsfly LLC · Somerton, AZBuilt 1977 · S/N 15279775N757JXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279787N757JYBreuer Lisa M · Horseshoe Bend, IDBuilt 1977 · S/N 15279788N757KFBob Hoover Academy · Salinas, CABuilt 1977 · S/N 15279795N757KMClover Park Technical College · Tacoma, WABuilt 1977 · S/N 15279801N757KPPhill-Air Inc · Dover, DEBuilt 1978 · S/N 28-7816616N757KXDamian Davis Construction Co · Candler, NCBuilt 1977 · S/N 15279811N757LKloss Todd T · San Antonio, TXBuilt 1998 · S/N 24844N757LBSwaney Brian W · Pendleton, SCBuilt 1977 · S/N 15279815N757LELake Elmo Aero LLC · Lake Elmo, MNS/N 17266022N757LGMamet Oren · Andover, MABuilt 1977 · S/N 15279820N757LHWoldow Frederic A · Morton, ILBuilt 2003 · S/N 81279N757LMYeary Clifton K · Quitaque, TXBuilt 1977 · S/N 15279825N757LNWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279826N757LPPrice Thomas E · Ogden, UTFirst renewal noticeBuilt 1977 · S/N 15279827N757LXSt Louis Flight Training LLC · Cahokia, ILBuilt 1977 · S/N 15279835N757LYHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279836N757MGOhio Gypsum Floors LLC · Westerville, OHBuilt 1977 · S/N 15279844N757MK101 Flight LLC · Waterford, MIBuilt 1974 · S/N 17264629N757MLSchaffer Michael W · New Meadows, IDBuilt 2013 · S/N 556-2013N757MMDsr-Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15279849N757MPAvcorp Holdings Inc · Jackson, MIBuilt 1977 · S/N 15279851N757MSAngel Aviation Inc · Peoria, AZS/N 15279854N757MYStaley Grady R · Liberty, NCBuilt 1977 · S/N 15279860N757NGWeisman Craig A · Falls Of Rough, KYBuilt 1977 · S/N 15279868N757NJSpace Coast Aircraft Co · Merritt Island, FLBuilt 1977 · S/N 15279870N757NNCarton David M · Claremont, NHBuilt 1977 · S/N 15279874N757NQA&R Aero LLC · Sacramento, CABuilt 1977 · S/N 15279876N757PMKaiser Gavin · Peachtree City, GAS/N 15279896N757PPFields Joseph H · Placerville, CABuilt 1977 · S/N 15279898N757PTPavlock Russell H · Tinley Park, ILBuilt 1977 · S/N 15279902N757QBHutchison William B · Canton, OKBuilt 1977 · S/N 15279910N757QHWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279916N757QJWaters Thomas J · Hampton, GABuilt 1977 · S/N 15279917N757QQKostelecky Scott J · Decatur, TXBuilt 1977 · S/N 15279923N757RLRudak Phillip Richard · Wethersfield, CTBuilt 1977 · S/N 15279943N757RNSky Aviation & Maintenance Inc · Wildomar, CAS/N 15279945N757RPBoyne Valley Flyers Club Inc · Boyne Falls, MIBuilt 1977 · S/N 15279946N757RTEnright Darren R · Lakeville, MNBuilt 1977 · S/N 15279950
Back to AD 90-04-06 R1