AD 2000-04-01

Registered aircraft · 5,676

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:2000-04-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-01')
  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.

N1444CFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9890N1447LHall Daniel W · Westlake Village, CABuilt 2008 · S/N T20608815N1448ZNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9891N1449CAb Prop Plane I LLC · Metairie, LABuilt 2005 · S/N 172S9892N144CKClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13552N144GRegistration Pending · Waco, TXRegistration pendingBuilt 2020 · S/N T20609598N144MEBell Enterprises Inc · Falls Church, VABuilt 2000 · S/N 172S8428N1458HMosle Air LLC · Far Hills, NJBuilt 2007 · S/N T20608765N145HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2001 · S/N 172S8745N145MEAbdelmotal Elsadig · Pearland, TXBuilt 2000 · S/N 172S8429N1460TJlj Aviation LLC · Amarillo, TXBuilt 2007 · S/N T20608767N14623Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 172S10430N1463FSun Aircraft Management LLC · Ormond Beach, FLBuilt 2005 · S/N 172S9895N1464CEdb Air Inc · Wilsonville, ORBuilt 2005 · S/N 172S9897N14669Lowman Henry B Trustee · El Granada, CABuilt 2007 · S/N 172S10444N1468EMachado Donald C Jr · Honolulu, HIBuilt 2007 · S/N 172S10446N146NEAngle Mark W · Lake Orion, MIBuilt 1998 · S/N 18280221N146TCN146tc LLC · Minneapolis, MNBuilt 2002 · S/N 172S9146N146WHAmick Ralph O · Hatteras, NCS/N 18280304N1472PFlight School Of Texas LLC · Wilmington, DEBuilt 2005 · S/N 172S9899N147GWAllen Air LLC · Creola, ALBuilt 2011 · S/N T20609022N147HAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10219N147PASetki Air LLC · Wilmington, DEBuilt 2024 · S/N T20609772N147SASteeda Autosports Inc · Pompano Beach, FLBuilt 2014 · S/N T20609155N14814Florida Flight Training Center Inc · Venice, FLBuilt 2007 · S/N 172S10451N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896N1488TTanana Leasing LLC · Fairbanks, AKS/N T20608541N148DWVantage Aviation USA LLC · Tampa, FLBuilt 2013 · S/N T20609091N148SMSarasota Westwind Flyers Inc · Sarasota, FLS/N 18280040N149DWRbf Aero · Wilmington, DEBuilt 2013 · S/N T20609097N149LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13125N149MEMccrary Mike M · Fairhope, ALBuilt 2000 · S/N 18280721N149UDW Air LLC · Chicago, ILBuilt 2003 · S/N 17281185N14PVRogers Michael P · Neenah, WIBuilt 2003 · S/N 172S9528N14WGWest Coast Equipment Leasing LLC · Aurora, ORFirst renewal noticeBuilt 2019 · S/N 172S12415N14WLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609857N1502EElizbeth City State University · Elizabeth City, NCBuilt 2005 · S/N 172S9900N15031Young J D · Plano, TXBuilt 2007 · S/N T20608725N1507XGolf November Aero LLC · Sunnyvale, CABuilt 2005 · S/N 172S9903N150SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11565N150TESummit Air LLC · San Diego, CABuilt 2009 · S/N 172S10996N150TH150th Aero Flying Club · Morristown, NJBuilt 2003 · S/N 172S9453N151BSEvans Linda J · North Wales, PABuilt 2001 · S/N 18280934N151MELoweth William A · Noank, CTBuilt 2000 · S/N 18280722N151ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608588N15206Megwetch Aviation LLC · Auburn, MES/N T20609214N15222Southeast Aircraft Leasing LLC · Jacksonville, FLBuilt 2007 · S/N 172S10454N1522RN1522r LLC · Mequon, WIBuilt 2008 · S/N 172S10716
Back to AD 2000-04-01