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.

N1122TAircraft Solutions Group LLC · Englewood, COBuilt 2019 · S/N 172S12416N1123FUrsus Air Services · Anchorage, AKBuilt 2002 · S/N 20608173N1127DWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10247N1128WFlorida Department Of Law Enforcement · Tallahassee, FLBuilt 2017 · S/N T20609512N1129CLanier Equipment Leasing LLC · Gainesville, GABuilt 2018 · S/N 172S12227N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380N1132WC Flying K Aviation LLC · Savery, WYFirst renewal noticeBuilt 2006 · S/N 172S10125N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316N11345Enviroplus Consulting Inc · Rosamond, CABuilt 2006 · S/N T20608668N11379Bas Part Sales LLC · Greeley, COBuilt 1999 · S/N 20608077N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182N113CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N T20609735N113KHTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609859N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339N1154GPlane Nonsense Inc · Middletown, DEBuilt 2006 · S/N 172S10126N1154WAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10608N1155MLagasse Michael · Newburyport, MABuilt 2006 · S/N T20608683N1155PN1155p Corp Trustee · Wilmington, DEBuilt 2003 · S/N 20608193N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627N1158QN1158q LLC · Palm City, FLBuilt 2006 · S/N 172S10354N1158VAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10355N1159KCavu Aero LLC · Marietta, GABuilt 2006 · S/N 172S10357N1159ZThunderfighter LLC · Englewood, COBuilt 2006 · S/N 172S10362N115CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12330N115FJFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10784N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819N115LWCrest Airpark Inc · Kent, WABuilt 2005 · S/N 172S9868N115PFHigh Tech Metals Inc · Harrisburg, PABuilt 1998 · S/N 18280224N115SV115sv LLC · Lamar, MOBuilt 2004 · S/N 172S9663N115TAAtp Aircraft 7 LLC · Wilmington, DEBuilt 2018 · S/N 172S12145N11614Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10360N1165YUgly Johns Aircraft LLC · Afton, OKBuilt 2006 · S/N T20608686N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820N116MVWing And Rotor Transportation Holdings LLC · Morristown, NJBuilt 2002 · S/N T20608357N116VGBruns Phillip T · Shiro, TXBuilt 1998 · S/N 18280346N116WBDunch David J Trustee · Poland, OHBuilt 1998 · S/N 18280170N116WETextron Aviation Inc · Wichita, KSS/N 172S13611N116ZXVranjes Peter · Johnstown, COBuilt 1997 · S/N 18280042N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821
Back to AD 2000-04-01