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.

N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098N4674ZHoadley Todd F · Springfield, OHBuilt 1961 · S/N 22-8207N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102N46764Hatbright Farm LLC · Wilmington, DEBuilt 1954 · S/N 18-3913N4676FSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7715059N4676WZaid LLC · Windermere, FLBuilt 1978 · S/N 13252N4676ZNielsen Nancy A · Eugene, ORBuilt 1961 · S/N 22-8209N46773Macannamac Inc · Millinocket, MEBuilt 1954 · S/N 18-3591N46775Lookner Augustus · Owls Head, MEBuilt 1954 · S/N 18-3594N4677RFields Michael L · Rockwood, TNS/N 28-21434N4677SSchutt Michael J · Kimberling City, MOS/N 101N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436N4678ZQrh LLC · Bartlesville, OKBuilt 1961 · S/N 22-8213N46798Shermer Darlene Francis · Brooklyn Park, MNBuilt 1954 · S/N 183327N4679GFlightime Inc · Elkhart, INS/N 17273305N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808N4679WBravo Whiskey LLC · Cascade, COBuilt 1978 · S/N 13255N467AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843741N467AT467at LLC · Frankfort, ILBuilt 1968 · S/N 17700879N467CMIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 17280859N467DKRegistered aircraftBuilt 1995 · S/N 467N467FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020067N467GRRoach Gene T · Frankfort, KYS/N 892N467PEOkane James K · Noblesville, INBuilt 2013 · S/N 1N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649N467TFHarts Joel D · Coffeyville, KSBuilt 1995 · S/N 1N467WPPalmer Thomas T · Kapowsin, WABuilt 1943 · S/N 75-4828N46803Ken Graham Phd Inc · Sioux Falls, SDBuilt 1979 · S/N 15283108N4680JCorral Oscar L · Ft Stockton, TXS/N 350N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439N4680ZPropelling The Gospel Missions Inc · Standish, MEBuilt 1961 · S/N 22-8215N4681JRose Jeffrey R · Niceville, FLS/N 28R-30581N46826Registration Pending · Tampa, FLRegistration pendingBuilt 1979 · S/N 15283114N46828Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 2009N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330N4682JAhz Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30561N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441N4683TBatchelor William · Sicklerville, NJBuilt 1972 · S/N 28-7225199N46846Boudreau Robert D · Rusk, TXBuilt 1978 · S/N AB005N4684CSmith Cameron T · Placitas, NMBuilt 2008 · S/N 68N4684HHarvey Robert C · Hortonville, WIBuilt 1948 · S/N 15-377N4684JByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28R-30585N4684ZGordon Stephen M · Velpen, INBuilt 1961 · S/N 22-8219N46854Phillips Joe Christopher · Grand Prairie, TXBuilt 1979 · S/N 15283121N4685JGaither William W · Shallotte, NCBuilt 1968 · S/N 28R-30586N4685SSeneca Aeronautical Services LLC · Wilmington, DEBuilt 1965 · S/N EC-1
Back to AD 90-04-06 R1