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.

N413DPYale Companies LLC DBA · Fishers, INBuilt 2006 · S/N 4496234N413EBG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 172RG0113N413EFIsland Aviation LLC · East Greenwich, RIBuilt 1974 · S/N 28R-7435173N413JSClearwake Inc · Kaysville, UTBuilt 1984 · S/N 8042-CN413KTAce Tomato Company LLC · Mcgregor, TXBuilt 2005 · S/N 2843608N413LHRatcliff Dustin Matthew · Saltville, VABuilt 2008 · S/N S1925N413LMRba LLC · Kimberly, IDBuilt 2007 · S/N 60396N413MASterling Flight Training LLC · Jacksonville, FLBuilt 1976 · S/N 17267164N413MMDoyle Brian G · Westfield, MABuilt 1960 · S/N 1005N413NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010006N413RBLarson Cody Q · Dillingham, AKBuilt 2003 · S/N 413RN413THPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020252N413WCBradshaw Larry C · Edgewood, TXBuilt 2009 · S/N 91607N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818N413ZPPettinger Tom W · Cody, WYBuilt 2004 · S/N 8-4705N4140JStone Raymond M · Moore, OKBuilt 1966 · S/N 28-22464N4140PRenda Gregory L · Saratoga, CABuilt 1999 · S/N 21064CN4140WBird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843228N4140XOtt Dean R · Carrollton, OHS/N 240N4140YBuckman Dean D · Monroe City, MOBuilt 1976 · S/N 1178-76N4140ZMeierotto Jeff T · Two Rivers, AKBuilt 1965 · S/N 18-8213N41412Walters Haskell L · Gold Hill, NCBuilt 1974 · S/N 28-7415204N41415Cavins Todd J · Stillwater, OKBuilt 1974 · S/N 28-7405101N41416Lewis Elijah J · Luthersville, GABuilt 1974 · S/N 28R-7435179N41419Ater Mark · Greenville, OHBuilt 1974 · S/N 28-7425237N4141HBizy Eves Enterprises LLC · San Antonio, TXS/N 15-24N4141KKimminau Jeremy · Sacramento, CABuilt 1967 · S/N 680006N4141UMoss James L · Lansing, IABuilt 1998 · S/N 2843125N4141YWells Kevin R · Elko, NVBuilt 1976 · S/N 1179-76N4141ZBalmer Jeffrey A · Crosslake, MNBuilt 1964 · S/N 18-8215N41421Blue Angel Properties LLC · Poland, OHBuilt 1974 · S/N 28-7415208N41429Straight Arrow LLC · Kuna, IDBuilt 1974 · S/N 28R-7435180N4142BKnutson Wayne R · Tioga, NDBuilt 1953 · S/N 520-47N4142MMiddleton William A Jr · Crestwood, KYBuilt 1947 · S/N 12-3041N4142YRegistered aircraftBuilt 1976 · S/N 279-76N41434Groner Frank · Montrose, ALBuilt 1974 · S/N 28-7415212N41439Lesher James · Farmington, NMBuilt 1974 · S/N 28R-7435183N4143ASkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843217N4143PSparrowhawk Aviation · Manvel, TXBuilt 1959 · S/N 23-1624N4143USwerczek Gerald Edward Jr · Tallahassee, FLBuilt 1999 · S/N 2843308N4143XBoeing Co · Renton, WABuilt 1968 · S/N 243N4143YHasenfus Heidi J · Green Cove Springs, FLBuilt 1977 · S/N 236-77N4143ZRavenscroft Brant A · Box Elder, SDBuilt 1965 · S/N 18-8221N41449Maccani Mark J · Bessemer, MIBuilt 1974 · S/N 28-7405104N4144ETradewind LLC · Wasilla, AKBuilt 1978 · S/N 18-7809084N4144JMclean Yvonne A · Warfordsburg, PABuilt 1966 · S/N 28-22468N4144KBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843145N4144MSannon Michael R · Fairview, MTBuilt 1947 · S/N 12-3044N4144PChandler Air Service Inc · Chandler, AZBuilt 1998 · S/N 2843121
Back to AD 90-04-06 R1