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.

N7067YCactus Skybolt Aviation LLC · Athens, ALBuilt 1963 · S/N 30-80N7068DDebach Mike J · Troy, PABuilt 1957 · S/N 18-5608N7068QWestwind Aviation Inc · Bremerton, WABuilt 1972 · S/N 17260368N7068YAdvanced Aircrew Training LLC · Nashua, NHBuilt 1963 · S/N 30-81N70699Cencer Kevin J · Clear Lake, MNBuilt 1966 · S/N 18-8357N7069BHarper Bryan K · Junction City, ORBuilt 1956 · S/N 18-5143N7069GAjf Enterprises LLC · Des Moines, IABuilt 1969 · S/N 17258769N7069KPlatinum Commercial Company LLC · Platinum, AKBuilt 1950 · S/N 20-174N7069QFlakker Michael E · Gold Hill, NCS/N 17260369N7069RMccoy Evan Tyler · Tullahoma, TNBuilt 1966 · S/N 28-21770N7069WBirmingham Michael F · Goldsboro, NCBuilt 1962 · S/N 28-818N706BHSilver Lance Aviation LLC · Ketchum, IDBuilt 2006 · S/N 2354N706BKBishop Kevin A · Dana, INBuilt 2006 · S/N 597N706CBMetal Feathers Inc · Ovilla, TXBuilt 2008 · S/N 72847N706CFRegistered aircraftBuilt 1963 · S/N 127N706DAFlycarolina LLC · Charlotte, NCBuilt 1980 · S/N 17274339N706DEBradley Aircraft Company LLC · Columbus, INBuilt 1979 · S/N 17272596N706FLTime Flys Idaho LLC · Clarkston, WAS/N 28-7225300N706KSSzmania Kris J · Rossford, OHBuilt 1987 · S/N 706N706LA4 Winds Consulting LLC · Nashua, NHBuilt 1995 · S/N 003N706LGRegistered aircraftBuilt 1972 · S/N AA1A0414N706NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881023N706QRegistered aircraftBuilt 2017 · S/N 82588N706RAChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843899N706RPPuckett Rex L · Silver Creek, GABuilt 2008 · S/N 81244N706TGauntlett Robert Michael · Yukon, OKS/N TTN75N706UBMaliskey Paul D · Au Gres, MIBuilt 1970 · S/N 18-8912N706WCChilcott Bart L · Derby, KSBuilt 1965 · S/N 647N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770N7070PHytry Randal G · De Soto, WIBuilt 1960 · S/N 24-2222N7070RRegistration Pending · Seward, NERegistration pendingBuilt 1966 · S/N 28-21771N7070VCraven Bradley A · Logansport, INBuilt 1976 · S/N 20-1207N7070WFullerton Brice · Oroville, WAS/N 28-849N7070YBean James P · Tulsa, OKBuilt 1963 · S/N 30-83N70714State Of Alaska · Anchorage, AKBuilt 1979 · S/N 18-7909114N70718Youkey John N · Yuma, AZBuilt 2003 · S/N 037N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771N7071JMorales Felipe E · San Antonio, TXBuilt 2003 · S/N 2356N7071QSun Country Aero Club · The Villages, FLS/N 17260371N7071RKarabulut Semih · North Little Rock, ARS/N 28-21772N7071WTeigen Travis S · Glenwood City, WIBuilt 1962 · S/N 28-851N7071YJts Aircraft LLC · Rock Hill, SCS/N 30-84N7072BJenema Jerry W · Lake City, MIS/N 18-5147N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772N7072KElliott Troy D · Star, IDBuilt 1950 · S/N 20-178N7072LPolsin Thomas H · Lowell, WIBuilt 1993 · S/N 05N7072PRegistration Pending · Kalispell, MTRegistration pendingBuilt 1960 · S/N 24-2224N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372N7072RMckinley Matthew R · Sault Sainte Marie, MIS/N 28-21773N7072WNelson David L · Laporte, INBuilt 1962 · S/N 28-852
Back to AD 90-04-06 R1