OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N358TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881858N358VAChapman James H · Mebane, NCBuilt 2013 · S/N 25218N358WGenco Holdings LLC Series A · Corpus Christi, TXBuilt 1966 · S/N 3417N359Wow Time LLC · Appleton, WIS/N 224N35905Morgan George Scott · Litchfield Park, AZBuilt 1976 · S/N 177RG1074N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545N35913Allen John A · Hollister, MOBuilt 1976 · S/N 177RG1076N35914Dunn Meghan Elizabeth · Mckinney, TXBuilt 1976 · S/N 177RG1077N3591FWolfe Robert G · West Columbia, SCBuilt 1970 · S/N 17259225N3591MScheibe Marvin E · Wooster, OHBuilt 1947 · S/N 12-2437N3591NPeperuka LLC · Olympia, WABuilt 1967 · S/N 680108N3591RAwmr LLC · Conroe, TXBuilt 1970 · S/N 28-5704N3592AKyle Allyn B · Snohomish, WABuilt 1953 · S/N 18-3022N3592KBeckler Benjamin C · Middle Granville, NYBuilt 1967 · S/N 28-23647N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550N3592QCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1973 · S/N 17261692N3592RBurnt Ridge LLC · Kalispell, MTBuilt 1969 · S/N 28-5705N3592XBryant David Wayne · Ada, OKBuilt 1968 · S/N 680161N35936Doncar LLC · Baden, PABuilt 1976 · S/N 177RG1081N35937Glaser Don E DBA · Willow, AKFirst renewal noticeBuilt 1975 · S/N U20602812N35939Aarons Daniel A · Berkeley, CABuilt 1976 · S/N 177RG1082N3593FEakin Robert C · Franklin, PABuilt 1970 · S/N 17259400N3593QKettunen Alan C · Ashtabula, OHBuilt 1973 · S/N 17261693N35942Schlichting Mark A · Newborn, GABuilt 1976 · S/N 177RG1083N3594MThacker William E · Chenoa, ILS/N 12-2439N3594QGribble Ted A · Paris, TXBuilt 1973 · S/N 17261694N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388N35966Colin Tony Ray · Waunakee, WIS/N 6683N35967Smith Richard D · Williamstown, OHFirst renewal noticeBuilt 1941 · S/N 6680N3596ASjostedt Brad D · Cordova, AKBuilt 1953 · S/N 18-3026N3596KStall Breakers LLC · Sachse, TXBuilt 1967 · S/N 28-23648N35976Shoemaker Calvin D · Los Angeles, CAFirst renewal noticeBuilt 1976 · S/N 177RG1087N3597AN3597a LLC · Rockford, MIS/N 18-3027N3597EBlue Bird Aero Club Inc · Bonne Terre, MOBuilt 1978 · S/N 17271601N3597KQuinn Knives LLC · Julian, CABuilt 1967 · S/N 28-23649N3597PBickford Tierra L · Big Lake, AKBuilt 1955 · S/N 18-4555N3598MOlmstead Dorothy E · Talkeetna, AKBuilt 1947 · S/N 12-2444N3599AReed John S · Wasilla, AKBuilt 1953 · S/N 18-3011N3599HSitter Duane A · Hayward, CABuilt 1977 · S/N 20-1238N3599ZBell Mark W · Soldotna, AKS/N 18-7393N359ACRunde Warren N · Concord, NHBuilt 2009 · S/N 1454-2009N359ALTyson Aviation LLC · Sherrills Ford, NCBuilt 1973 · S/N 17262020N359BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881807N359CAFly Inverted LLC · Brighton, MIBuilt 2005 · S/N 997-2005N359DWDurrell Lee W · Channel IslandsS/N 30-770N359FAStratus Rr LLC · New Castle, DEBuilt 2022 · S/N 28020059N359FSJohnson Air LLC · Anselmo, NEBuilt 1990 · S/N 4100CN359GCAir Papa Bravo Inc · Altamonte Springs, FLBuilt 2017 · S/N 5410N359HEiden Ryan J · Central, AKBuilt 2024 · S/N JA2102155
Back to AD 90-04-06 R1