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.

N52936Reimer Dean R · Yuma, AZBuilt 1978 · S/N 177RG1313N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641N5293HPierce Stephan · Graham, TXBuilt 1949 · S/N 16-97N5293KBrooks Jimmy · O Fallon, ILS/N 17274049N5293SBullock Agency Inc · Saint Charles, ILBuilt 1970 · S/N 28-26841N5294Brown Kevin Lee · Broseley, MOBuilt 1971 · S/N MC-94N52944Masiero Christophe D · Winter Garden, FLBuilt 1978 · S/N 177RG1315N52946Pluntze Stephen C · El Segundo, CABuilt 1977 · S/N 177RG1317N5294HWingo John W Jr · Washington, DCBuilt 1949 · S/N 16-98N5294LBreidenbach Amy K · Onalaska, WIBuilt 1968 · S/N 28-4595N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508N5294XCarrigan Roy K · Oak Grove, MNS/N 2220N5294ZMorpeth Dorinda · Fortson, GABuilt 1961 · S/N 22-8994N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642N52951Gladis Glen W · Locust Grove, GABuilt 1942 · S/N 75-7007N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559N5295KWright Allan Paul · Lacombe, LABuilt 1950 · S/N NAV-4-2195BN5295SAlzarqa Saleh A · Fairfax, VABuilt 1970 · S/N 28-26941N5295ZFawcett Debra K · Baraboo, WIBuilt 1961 · S/N 22-8995N5296BRobertson Ca · Phoenix, AZS/N 1158N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050N5296PFlanagan Robert Howard · Willows, CABuilt 1958 · S/N 24-337N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510N5296TGq Aviation LLC · Cherry Hill, NJBuilt 1972 · S/N 34-7250244N5297BHughes Shaman · Cedaredge, COBuilt 1956 · S/N 1159N5297LIndulgences Inc · Putnam Valley, NYBuilt 1968 · S/N 28-4599N5297MAllard John R · Circleville, OHS/N 15284518N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511N5297TMid Atlantic Air Museum · Reading, PABuilt 1972 · S/N 34-7250245N5297WTausch Eddie W · Port Aransas, TXS/N 28-348N5297YBlotsky Jim Darin · Fargo, NDBuilt 1963 · S/N 18-8022N52987Lewis Nathan A Trustee · Watsonville, CABuilt 1978 · S/N 177RG1323N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512N5298TPleasant Valley Aviation Inc · Bellefonte, PABuilt 1972 · S/N 28-7225396N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501N5298WAim High Aviation LLC · Coral Springs, FLBuilt 1962 · S/N 28-349N52990Hurley Drew M · Port Orange, FLBuilt 1978 · S/N 177RG1324N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501N5299LSerafini Ronald S · Murphy, NCS/N 28-4601N5299SRichard Douglas G · Decatur, TXBuilt 1970 · S/N 28-26744N5299WPatterson Guy R Jr · Glencoe, KYBuilt 1962 · S/N 28-350N5299ZWilliams Robert M · Red Hook, NYBuilt 1961 · S/N 22-8786N529BHVanhouten Philip D · Wallkill, NYS/N 529WN529CANeufeld Don I · Fairview, OKS/N 17269104
Back to AD 90-04-06 R1